Linked Servers ON SQL Server 2005, Access 2007

[Andy Couch]

I am having a problem with linked servers, using SQL Server 2005 (SP2),
Access 2007 (New accdb file format) using Microsoft.ACE.OLEDB.12.0 on Vista.

I can create the linked server, running the test gives OK, the tree expands
to the Tables level, but then gives an Error.

Cannot fetch a row from OLEDB provider, Error 7399

I get exactly the same problems when attempting to use OPENROWSET

I can however use Visual Studio to link to the accdb, and I can also create
linked servers and use OPENROWSET to old .MDB Access files.

Any ideas ?

Thanks

Andy Couch

[Josh]

Hi - I'm having a similiar issue...

Post by Andy Couch
I am having a problem with linked servers, using SQL Server 2005 (SP2),
Access 2007 (New accdb file format) using Microsoft.ACE.OLEDB.12.0 on Vista.
I can create the linked server, running the test gives OK, the tree expands
to the Tables level, but then gives an Error.
Cannot fetch a row from OLEDB provider, Error 7399
I get exactly the same problems when attempting to use OPENROWSET
I can however use Visual Studio to link to the accdb, and I can also create
linked servers and use OPENROWSET to old .MDB Access files.
Any ideas ?
Thanks
Andy Couch