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

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

Linked Server problem

Hi,

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???

Thanks

Iain
0
iJolly4
Asked:
iJolly4
1 Solution
 
iJolly4Author Commented:
http://support.microsoft.com/kb/285833/EN-US/

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

PAQ_Man
Community Support Moderator
0

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