MySQL Forums
Forum List  »  Connector/ODBC

MS Access ODBC Copy Table to Access Drops Primary Keys
Posted by: Dan Weller
Date: May 16, 2018 10:13PM

We are using Access as a front-end to MySQL. Everything works fine when we use live ODBC Links to the MySQL tables that are on a server. We are using the MySQL 5.2 driver.

For development, we sometimes use the ODBC "Copy" tables to get the actual tables in our local machine. In this case, none of the tables have primary keys. This causes several problems with queries.

However, if we use the "Convert to Local Table" function, the resulting local tables do have the correct primary keys.

All of the users are on Windows 10 and use Access 2007,2010 and 2016. We have the same problem with all of the machines.

Thanks in advance for any help with this issue.

Options: ReplyQuote


Subject
Written By
Posted
MS Access ODBC Copy Table to Access Drops Primary Keys
May 16, 2018 10:13PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.