SSMA for Access - Migration Assistant Wizard fails at link tables
I was able to work around the problem by doing the following:


Allow the migration assistant to complete (with link converted tables failing)
Manually add MySQL linked tables to Access


Open Access, select External Data-&gt;New Data Source-&gt;From Other Sources-&gt;ODBC Database
Select Link to the data source by creating a linked table
Select your ODBC driver file or source
Enter credentials
Select tables you want to link

Delete Access tables and rename MySQL tables


From Tables list, right click first Access table and delete
Right-click corresponding MySQL table and rename to exactly match deleted Access table
Repeat for every table you want to re-map



Provided that you rename each MySQL table to match the deleted Access tables, all queries should work.