SSMA: Error 80040154 on Windows 7 - 64 bits

Question

I am getting the following error message when adding a new database to SSMA:

"Retrieving the COM class factory for component with CLSID {CD7791B9-43FD-42C5-AE42-8DD2811F0419} failed due to the following error: 80040154. This error may be a result of running SSMA as 64-bit application while having only 32-bit connectivity components installed or vice versa. Please run SSMA in 32-bit (or 64-bit) mode or consider updating your connectivity components from http://go.microsoft.com/fwlink/?LinkId=197502. An error occurred while loading database content."

I am running Windows 7 64bits, Office 2010 32 bits. I have installed the SQL Server Native Client x64.

Note that I migrated this database before using a 32bits machine. I can use the access front end on my new 64bits machine (ie: I can connect to Azure).
Is there a 64bits version of SSMA I can donwload?

Any help would be much appreciated. Thank you!

Answer 1

Just managed to make it work by following the procedure described here (http://www.databasemigrate.com/Discussions/tabid/56/forumid/3/postid/6/scope/posts/Default.aspx) and making some changes to suit SSMA for Access.

Isn't there a simpler way to use SSMA for Access on a x64 OS!?!

Answer 2

Hi,

I tested SSMS with my Windows 7 64bit machine and it works. According to the error message you posted, this should be a 64bit provider issue. You need to install AccessDatabaseEngine_2010_X64, however your Office is 32, you can only install AccessDatabaseEngine_2010_x86. So I’m afraid you have to install Office 2010 64bit, and then ensure you have installed AccessDatabaseEngine_2010_X64:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

 

Thanks,

Raymond

---

Raymond Li - MSFT

Answer 3

Hi Raymond.

 

Since I could make it work by using corflags.exe without changing my config. (Windows 7 64bits + Office 32bits ), would it be possible to bypass the use of corflags in a future vesion of SSMA?

More and more systems are sold with WIndows 7 64bits + Office 32bits around here and I would not be surprised if more Access users encounter this problem in the future when migrating to Azure.

Just my two cents worth

 

Thierry

Answer 4

SSMA installs 32-bit and 64-bit binaries on a 64-bit platform. If you have Access 32-bit installed, you can use SSMA 32-bit binary (shortcut available in Programs menu) and SSMA should work fine. SSMA 32-bit requires DAO 32bit libraries and SSMA 64-bit requires 64-bit DAP libraries.

Keshav Ramarao

SQL Server Migration Assistant Team

Answer 5

Thank you Keshav. I always used the shortcut on my desktop without realizing that there was a link to both versions of SSMA (32/64) in the Start Menu!.