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 https://go.microsoft.com/fwlink/?linkid=834402. 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.

Question:

  • 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)

EDIT:

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

Thank you for any hint...



Related Questions


Updated July 18, 2016 08:02 AM

Updated July 07, 2019 23:06 PM

Updated July 09, 2019 04:06 AM

Updated September 22, 2017 11:06 AM

Updated February 23, 2019 20:06 PM