Forum Discussion
Microsoft SQL Server Migration Assistant v7.7 for Access now includes 32bit version!
Juan,
While this is great news, it is still not necessarily easy to know which version to choose. I have a 64-bit computer, but a Click to Run (Office 365) version of Access 32-bit. I found the best fit in this environment was to install the 32-bit version of SQL Server Migration Assistant (even though my machine was 64-bit) - in other words, install the same version of SSMA as you have of Office. I also had to install 32-bit runtime for Access 2013 (the trick here is to go one version lower than your current version of Access) to get the database engine which does not come as part of the Click to Run application. I actually had lots more trouble than that but I think it was because I made the wrong choices initially. I would like to write or see a nice article on when to install what and why from someone in the near future!