I have an Access 2010 application that uses several linked MySQL tables. These work just fine.
BUT, we sometimes want to bring down the DB data to local tables. This is done by using the ODBC "Import the source table into a new table ...". This does import the data, but the primary keys are not in the imported tables. They ARE IN the linked tables. The missing PKs really mess up some of our queries.
I did notice that you can right-click a LINKED table and select "convert to local table" and the resulting table does have the primary keys. This is fine, but some of our developers are using Access 2007 which doesn't have the "convert to local" command. Plus, this is a pain to do when you have 50+ tables in the DB.
I have tested the same scenario with a SQLServer DB and got the same results. I have also tried with Access 2016 and still don't get the primary keys.
So, is this a "feature" of Access, or is there a way to get the PKs in the imported tables?
Thanks for any suggestions.