Missing tables in MS SQL Server Migration assistant for Access 2010

Question

I am using Access 2010 and have upsized 29 of 30 tables using the wizard. I am trying to use the migration assistant for Access  to get the last table data, everything looks good except I don't see any of the tables in the Access Metadata Explorer. The new tables are in my SQLExpress db except for the largest (invoices) which is 203K records.

Answer 1

Hello,

Which release of SSMA for Access you using? You can try to download the latest version from the following link:
http://www.microsoft.com/en-in/download/details.aspx?id=28763

The following thread is about a similar issue, please refer to:
http://www.experts-exchange.com/blogs/matrixdevelopment/B_7483-SQL-Server-Migration-Assistant-for-Access-SSMAA-5-2-not-displaying-Tables-in-metadata-explorer.html

Regards,
Fanny Liu

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
Thanks for helping make community forums a great place.

Answer 2

That works great! Thanks for the tip.