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...
I also had no issue with the tool prior to 7/9--I'm now getting the same behavior of hanging at 'Connecting to database'. I rolled back the SSMA update from 8.21 to 8.20, but the issue persists. I noticed Office 365 received an update on 7/9 (Access 16.0.14131.20278), so I believe that's the culprit. . Very frustrating.
- Easy to test whether the Office update is the cause. Rollback to an earlier version of 365
For detailed instructions on how to rollback to an earlier version of 365, see https://support.microsoft.com/en-us/topic/how-to-revert-to-an-earlier-version-of-office-2bd5c457-a917-d57e-35a1-f709e3dda841
