SQL Migration Office 365: DAO missing

Question

Hello
What I want to do: Migrate a acessdata.accdb to SQL Database 2019 with SSMA 8.14. OS, Office and SSMA are 64 bit.
The error I get when loading the database: Retrieving the COM class factory for component with CLSID {CD7791B9-43FD-42C5-AE42-8DD2811F0419} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).

I did not find the solution to register the COM classe DAO for Office 365. Do you have an instruction for me how to solve this problem?

Thanks in advance.
@Monika Gera .badertscher@harsh.com .com

Answer 1

Hi @Monika Badertscher ，

Please refer to the following articles which might help:
Access connectivity components for SSMA
Converting Access Database to MSSQL Database Using Microsoft SQL Server Migration Assistant for Access
Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hey,

Starting from Office 365 v2007 everything should be registered when you install Office 365 Click-to-run. Can you please try to uninstall all standalone/redistributable/runtime MS Access installations, and repair/reinstall latest O365? Make sure you have both (SSMA and O365) with the same platform architecture (32 vs 64 bit).

Thanks,
Alex.