Forum Discussion
SQL Server Migration Assistant for Access - Hangs when selecting Access DB
I downloaded Microsoft SQL Server Migration Assistant for Access last week and successfully converted my local Access database to an online MS SQL database. After testing it for a week I decided to d...
This thread is not the newest anymore. However, I had the same issue after upgrading to SSMAA 8.25. Everything worked the day before and after the upgrade the same symptoms appeared.
My configuration WIN 10 64-bit; Office 365 64-bit. I work in an enterprise environment, so any rollback of O365 is out of discussion.
The final solution for me was to
1. uninstall SSMAA 64-bit version
2. uninstall Microsoft Access Database Engine 2016 Redistributable 64-bit version
3. reboot my machine
4. install SSMAA again 64-bit version
5. Install Microsoft Access Database Engine 2016 Redistributable 64-bit version
All was back to normal after this! Only removing/reinstallation of SSMAA didn't worked for me. Also other solutions with 32-bit and 64-bit that are mentioned here didn't worked.
Hope someone might find this helpful.
