Sample Header Ad - 728x90

SSMA cannot read meta data (missing runtime components)

0 votes
0 answers
888 views
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... ##UPDATE In the meanwhile I found [this (german) instruction](https://www.ugg.li/setup-fehler-office-16-click-to-run-extensibility-component-64-bit-registration/) how to find and remove the "Click-to-Run" services. In short: Go to %windir%\installer, make sure that explorer is showing you the column "Betreff" (I don't know, how this is called in English, might be "regarding"). You can find the MSI-packages. Copy them somewhere and perform a right-click. Now you can choose "uninstall". After removing these "click-to-run" stuff from my notebook I can proceed but run into the next error: > [...] because you have these Click-to-run installer based Office > programs installed on your computer 1) Microsoft Office 365 ProPlus - > en-us and 2) Microsoft Office 365 ProPlus - de-de". Windows Installer > and Click-to-Run editions of Office programs don't get along for this > version, so you can only have one type installed at a time. [...] So my new question is: Can we use SSMA together with MS-Access 365 and - if not - is there an alternative? Well, I might set up a pc just for this *one-time-issue*... Thank you for any hint...
Asked by Gottfried Lesigang (553 rep)
Sep 11, 2019, 09:55 AM
Last activity: Sep 11, 2019, 12:20 PM