May 2, 2007 at 9:35 pm
I have a linked server setup created on SQL Server which connects to MS Access database(Provide name is used is Microsoft Jet 4.0 OLE DB Prodiver). It does work good, but many time when I try to access the MS Access database through the linked server created on SQL Server I get the following error:
Error 7399: OLEDB Provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005.
Can anybody help in get rid of this error.
Thanks
May 3, 2007 at 10:55 am
The file may be in use. It may be in use by another connection of the same linked server.
You may want to check if the account that accesses your Access database has Write access on the parent folder of the access database file. If MS ACCESS database is opened first by an account that does not have WRITE access on the parent folder, it can not create a lock file <dbname>.ldb and the database opens in the exclusive mode even if all properties of connection and the database itself are set to shared mode. In this case the second connection can not open the file. This is the know issue.
Regards,Yelena Varsha
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply