[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1056
  • Last Modified:

Linked Server problem


I have created a linked server to an access database and this works fine on my local server.  I created the same linked server on my production server and this worked fine when I am workking on the production server.  If, however, within enterprise manager on my machine I register my production server  and try to look at the linked server that I created on the production server I get the following message:
Error 7399: OLE DB 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:  ]

If I try and run a query against the Linked server I get:
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.  
[OLE/DB provider returned message: The Microsoft Jet database engine cannot open the file '\\gbrxxx\applications\appln\Sales Compensation & Pipeline\SandRDetails\sales.mdb'.  It is already opened exclusively by another user, or you need permission to view its data.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005:   ].

Any ideas???


1 Solution
iJolly4Author Commented:

I have solved the problem with the above link.  The question is now closed.
PAQed with points refunded (250)

Community Support Moderator

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Tackle projects and never again get stuck behind a technical roadblock.
Join Now