SSMA 6.0 Error: Retrieving the COM class factory for component failed due to the following error: 80040154 Class not registered

Question

_{Sunday, December 21, 2014 11:04 PM}

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

All replies (8)

_{Wednesday, December 24, 2014 3:28 AM ✅Answered | 1 vote}

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

---

_{Monday, December 22, 2014 12:15 AM | 1 vote}

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

---

_{Monday, December 22, 2014 8:04 PM}

Hi Alberto-

Thanks for replying.

I am using the 32-bit version.

Regards,

Alan

---

_{Wednesday, December 24, 2014 3:49 PM}

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

---

_{Wednesday, February 4, 2015 3:44 AM}

I would like to add a few points from my own experience.

1. 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.
2. 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.

---

_{Wednesday, October 14, 2015 7:25 AM}

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

---

_{Monday, December 28, 2015 4:32 PM}

Same issue as noted above. This solution fixed the problem. Thanks for posting.

---

_{Monday, October 28, 2019 9:17 PM}

Same issue as noted above. This solution fixed the problem. Thanks for posting.