Microsoft SQL Server Migration Assistant for Access Issue on 64bit Systems

Issue:

On a Windows 64bit system running Microsoft Office 2010 64bit, when you attempt to migrate an Microsoft Access database to Microsoft SQL Server using the SSMA, you receive the following error:

Retrieving the COM class factory for component with CLSID {16AA0B9E-79AC-43B5-86CA-AB961FBEED5F} failed due to the following error: 80040154.

Resolution:

You can easily resolve this issue by installing the 2007 Office System Driver: Data Connectivity Components.  You can download it from this link:  http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

Advertisements

About jasontarby

Enterprise Architect / Network Engineer at SRA International, Inc.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s