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...
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
isladogs Thanks, but unfortunately I'm on a work PC where Office updates are managed company-wide, so I'm unable to test myself.
- OK that's a pity.
In that case. how were you able to get SSMA rolled back to 8.20?
I have exactly the same version of Office as you and am now downloading v8.21 of the Migration Assistant so I can try to replicate your issue. Are you able to upload a copy of the database you were trying to use with SSMA so I can use that in testing?
Have you tried all the usual steps - compile, compact, decompile, import to new blank database?- I have some freedom with small utilities, less so with Office 🙂
I can't share this particular database, but I just re-created the issue with a blank, single-table test database. Issue persisted with both .mdb and .accdb.
