We have an Access database (about 9 megs in size) with linked tables in it. The machine DSN shows that the information for the connection is correct. But when you try to open the table in Access, a dialog pops up to connect to the mysql server and the information is wrong. It has the wrong database name. We correct the information in the odbc dialog box so that it matches the DSN information and the table opens.
We have triple checked the odbc connections for windows; they are all correct. There's nothing in Access that references the wrong database. There's nothing in the registry. Deleting the linked tables and re-linking them and repairing the access database appears to fix the problem.
Has any one else experienced this or know what might be causing it? My only guess so far was that the mdb itself had become corrupt, which was why deleting and relinking the tables then repairing the database fixed the problem.
I'd appreciate any information you have.
Thanks,
bob
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]