Page 1 of 1
R&R10+ and MS Access
Posted: Fri Oct 17, 2003 9:18 am
by keithscs
Hello folks,____I^m trying to use R&R against a Microsoft Access database. When I connect via ODBC I get the error "No table names were found for this Data Source".____I^ve tried converting the database from Access 97 to 2000, using a file DSN and a system DSN, but everthing I try gives this error. Is MS Access supported in R&R10+? If so, any ideas what is wrong?____Thanks__Keith__SCS Harlow
=> RE: R&R10+ and MS Access
Posted: Mon Oct 20, 2003 1:24 pm
by kfleming
R&R does work against Access tables.__The two things that I would try are using__Tools->Database Utilities->Compact and Repair Database within Access and I would also try saving the database into a new directory and see if that helps.____Kathleen__R&R Support
==> RE: R&R10+ and MS Access
Posted: Tue Oct 21, 2003 10:14 am
by keithscs
Thanks for the help. Moving the .mdb file to a new directory solved it. The problem seems to have been that there was another, seperate, database in the same directory that was password protected. Note: the .mdb I was running against was not password protected.____By entering the user ID and password of the protected database into the ODBC control I can get the list of tables of the un-protected database. Looks like a bug somewhere.____Thanks__Keith__SCS Harlow