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.

  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.

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.