Migrate Access 2000 Database using SSMA 2005 for Access -

Hi

I am trying to migrate an Access 2000 database to SQL Server 2005 Express

On opening the Access database I get the following error:

Access Object Collector error: Database
     Unable to cast COM object of type 'Microsoft.Office.Interop.Access.Dao.DBEngineClass' to interface type 'Microsoft.Office.Interop.Access.Dao._DBEngine'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{00000021-0000-0010-8000-00AA006D2EA4}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).
     An error occurred while loading database content.

Hence I cannot read the tables or queries
The machine is running Windows XP SP3, .NET Framework 3.5 SP1 and SQL Server 2005 Express
What software I am missing ?

regards
Dec
dec7Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
dec7Author Commented:
Tried a different solution to ones referred to
0
All Courses

From novice to tech pro — start learning today.