problem with linked server (access 2007) to sql server 2005 express -- sql server (microsoft)

Aivars
4/5/2007 5:53:02 AM

Hello,
I receive the following error when querying a linked access 2007
database (as linked server) to sql server 2005 express:

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server
"underbase" reported an error. Access denied.
Msg 7301, Level 16, State 2, Line 1
Cannot obtain the required interface ("IID_IDBCreateCommand") from OLE
DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "underbase".

When I link an Access 2003 file (.mdb) with Jet.4.0 provider to sql
server 2005 express, everything works OK.

Can it be that this is a bug in Microsoft.ACE.OLEDB.12.0 provider?

Thanks,
Aivars

Todos Menos [MSFT]
4/9/2007 3:39:57 PM

if I were you; I would just build a classic SQL Server OLEDB
connection string

but more importantly; you should be using Access Data Projects with
Acc07 and SQL05-- that's a killer combo!

-Todos

[quoted text, click to view]

sql server (microsoft) : problem with linked server (access 2007) to sql server 2005 express