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

Posted on August 10, 2010 by jasontarby

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

About jasontarby

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

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

  1. Pingback: SQL Server Migration Assistant for Access nightmare – Explosive Insight

Leave a Reply

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

Gravatar
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 )

Cancel

Connecting to %s