asked on

SQL Server Migration Assist Error

I have been working on an Access 2013 project, with Access as the Front end and SQL Server 2014 as the back end.

Since I was new to SQL Server, the backend SQL Server tables were first created in Access and moved to SQL Server using the 32-bit SSMA. I moved dozens of tables to SQL Server with this process. It is a simple process and has been a great help. It even links the [now] SQL tables into the Access DB if you choose to.

I haven't used the SSMA in a few months but just had occasion to add a new table to the application. In the SSMA wizard I am now getting an error when I choose the Access acccb I want to transfer the table form. This is the error"

"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."

The error sure seems to indicate a mismatch between 32 bit and 64 bit versions.

I haven't knowingly made any changes to my environment since I last used 32-bit SSMA. I am trying to do this on the same computer as always, with the same Operating system (Win 7 Pro) , the same Office installation (32-bit 2013) and the same SQL product(SQL Server 2014 developer).

Any ideas what the issue is?

ASKER CERTIFIED SOLUTION

Karl Williams

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mlcktmguy

ASKER

I don't understand your response. I am using office professional for development

mlcktmguy

ASKER

Sorry, the 2013 version oh ms office pro

Karl Williams

It sounds like one or more of the supporting DLL's in no longer registered. On a system without MS Access, then you might need to reinstall the Redistributable. On your development system, your MS Access might be having trouble with a recently installed update (From Windows Update)

Scott McDaniel (EE MVE )

I would agree with Karl, that something has come undone on your installation. You can try an Office Repair, which might resolve this. Also be sure your Windows install is fully up to date.

Might need to remove and reinstall SSMA as well.

mlcktmguy

ASKER

Thanks, now I understand the connection. I uninstalled and re-installed SSMA 32-bit and reinstalled Office Pro 2013 but I'm still getting the same error.

SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mlcktmguy

ASKER

Thanks for the suggestion Karl and the confirmation Scott.

Installing the Redist and the uninstalling and re-installing SSAM 32-bit worked.