MS Access ODBC Copy Table to Access Drops Primary Keys

[Dan Weller]

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.