SQL Migration Office 365: DAO missing

Monika Badertscher 1 Reputation point
2020-09-30T10:08:06.55+00:00

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

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.
368 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. AmeliaGu-MSFT 13,886 Reputation points
    2020-10-01T02:41:18.6+00:00

    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.

    No comments

  2. Alexander Ivanov 486 Reputation points
    2020-10-20T02:26:54.57+00:00

    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.

    No comments