<div>
Tried a different solution to ones referred to
</div>


Tried a different solution to ones referred to

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I am trying to migrate an Access 2000 database to SQL Server 2005 Express<br />
<br />
On opening the Access database I get the following error:<br />
<br />
Access Object Collector error: Database<br />
&nbsp; &nbsp; &nbsp;Unable to cast COM object of type 'Microsoft.Office.Interop.<wbr />Access.Dao<wbr />.DBEngineC<wbr />lass' to interface type 'Microsoft.Office.Interop.<wbr />Access.Dao<wbr />._DBEngine<wbr />'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{00000021-0000-0010-8000-<wbr />00AA006D2E<wbr />A4}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).<br />
&nbsp; &nbsp; &nbsp;An error occurred while loading database content.<br />
<br />
Hence I cannot read the tables or queries<br />
The machine is running Windows XP SP3, .NET Framework 3.5 SP1 and SQL Server 2005 Express<br />
What software I am missing ?<br />
<br />
regards<br />
Dec
</div>
</div>


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

Migrate Access 2000 Database using SSMA 2005 for Access -

Microsoft Windows XP is the sixth release of the NT series of operating systems, and was the first to be marketed in a variety of editions: XP Home and XP Professional, designed for business and power users. The advanced features in XP Professional are generally disabled in Home Edition, but are there and can be activated. There were two 64-bit editions, an embedded edition and a tablet edition.

Windows XP

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.