SSMA cannot read meta data (missing runtime components)

by Shnugo   Last Updated September 11, 2019 10:06 AM

What I want to do should be rather easy: Use SSMA to transfer internal Access tables and queries to SQL-Server.

On my Notebook I'm running SQL-Server 2017 and Office 365 (32 bit)

As I have 32 bit Office (company's choice ...), I installed the "SSMAforAccess_8.4.0_x86.msi" from the official download site and get a warning during setup, that there are components missing with a download link where I can find "accessruntime_4288-1001_x86_en-us.exe" (same with x64).

I tried first the x86, but it fails, because there is a 64bit "Office 16 Click-to-Run Extensibility Component 64-bit Registration" on my system. And trying to install the x64 fails too, because there is a 32bit "Office 16 Click-to-Run Extensibility Component" on my system.

I can run SSMA without any problems, load the .accdb, connect to SQL-Server, but it fails to read the accdb's meta data:

Access Object Collector error: Database Die COM-Klassenfactory für die Komponente mit CLSID {CD7791B9-43FD-42C5-AE42-8DD2811F0419} konnte aufgrund des folgenden Fehlers nicht abgerufen werden: 80040154 Klasse nicht registriert (Ausnahme von HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)). Please make sure that you are using the correct version of SQL Server Migration Assistant. If you have 32-bit Microsoft Access installed, then you will need to use 32-bit version of the Migration Assistant. In order to use 64-bit version of Migration Assistant, you will need to install 64-bit Microsoft Access components available at An error occurred while loading database information.

The german part translates to: The COM-class could not be executed due to the given error (class not registered).

A search for the given CLSID brings me back to the access runtime components.


  • How can I use SSMA, if I cannot install the needed runtime?
  • Or: How can I install missing components, if the installation routine does not work (e.g. shift the DLL to GAC with gacutil manually)


In the meanwhile I tried to use SSMA x64 to no avail...

Thank you for any hint...

Related Questions

How to eliminate complex sub queries?

Updated July 07, 2019 23:06 PM

Export ms access report to excel vba

Updated September 22, 2017 11:06 AM

Restrict Front Ended User access to Form entry only

Updated February 23, 2019 20:06 PM