SSMA 6.0 Error: Retrieving the COM class factory for component failed due to the following error: 80040154 Class not registered
Category: sql server migration
Question
alank10 on Sun, 21 Dec 2014 23:04:46
I am running SQL Service Migration Assistant for Access 6.0 and I am getting the following error when I attempt 'Refresh from database':
Access Object Collector error: 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)). This error
may be a result of running SSMA as 64-bit application while having only 32-bit connectivity components installed or vice versa. You can run 32-bit SSMA application if you have 32-bit connectivity components or 64-bit SSMA application if you have 64-bit connectivity
components, shortcut to both 32-bit and 64-bit SSMA can be found under the Programs menu. You can also consider updating your connectivity components from
http://go.microsoft.com/fwlink/?LinkId=197502.
An error occurred while loading database content.
I've clicked on the link above and installed the Access 2010 Runtime that I found there, but that is not helping the problem.
I'm running Access 2013 (32-bit) on a Windows 8.1 (64-bit).
Please help.
Alan
Replies
Alberto Morillo on Mon, 22 Dec 2014 00:15:38
Hello,
Try using the 32-bit version of SSMA. You will find it on the Start menu as explained on the following article. SSMA 32-bit
will use DAO 32-bit and will work with Access 32-bit.
http://www.dummies.com/how-to/content/how-to-search-for-programsapps-in-windows-81.html
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
alank10 on Mon, 22 Dec 2014 20:04:36
Hi Alberto-
Thanks for replying.
I am using the 32-bit version.
Regards,
Alan
Lydia Zhang on Wed, 24 Dec 2014 03:28:50
I am using the 32-bit version.
Hi Alan,
Please download and install
Microsoft Access Database Engine 2010 Redistributable on your system, then check if you can run SQL Service Migration Assistant for Access 6.0 successfully.
Here is a similar blog for your reference.
http://www.explosiveinsight.com/Home/tabid/118/entryid/54/SQL-Server-Migration-Assistant-for-Access-nightmare.aspx
Thanks,
Lydia Zhang
alank10 on Wed, 24 Dec 2014 15:49:55
Hi Lydia-
Thank you - that worked.
Please ask Microsoft to fix this problem or make it part of the instructions when working with the SSMA.
Alan
mikesnp on Wed, 04 Feb 2015 03:44:14
I would like to add a few points from my own experience.
- If you are using Access 2013, download the 32-bit version of Microsoft Access 2013 Runtime from http://www.microsoft.com/en-us/download/details.aspx?id=39358. The file name is AccessRuntime_x86_en-us.exe.
- After installing the runtime software, when you load the project that experienced the error, right click on each database in the project and click "Refresh from database".
- Mike Brooks
SNP Technologies, inc.
ArikC on Wed, 14 Oct 2015 07:25:36
I'm with the same situation, Office 2013 32 bit and windows 7 64 bit. Still not working.
What exactly should I do? Just install ?
Thanks,
Arik
MRAcad on Mon, 28 Dec 2015 16:32:38
Same issue as noted above. This solution fixed the problem. Thanks for posting.
Gill Prod on Mon, 28 Oct 2019 21:17:15
Same issue as noted above. This solution fixed the problem. Thanks for posting.