I can't use SSMA for Access because the DAO component is missing. What should I do?

jennifer neighbors 40 Reputation points
2024-07-16T20:16:08.54+00:00

I can't use SSMA for Access. When I installed it, I got an error message that the DAO component was missing. What should I do? (It seems as though the Microsoft download page is still not working.)

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
538 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
881 questions
{count} votes

Accepted answer
  1. Erland Sommarskog 112.7K Reputation points MVP
    2024-07-16T21:56:19.4933333+00:00

    Link not working: https://www.microsoft.com/en-us/download/details.aspx?id=50040

    That link seem to work for me, using Firefox. Maybe you need to clear some browser cache?

    To be precise: the link takes me to a download page, I can press download up which I get a popup with a selection of different files. I checked one, and I then got a Save to dialog in my browser. However, I did not continue with actually downloading the file.


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.