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

Problem with Linked server to MS Access database

Hello,

This is my problem :

I have an mdb db in a share on the network without restrictrion... everybody have full control on this share...

Now, I want to link this database to my MS SQL Server.
When I launch Enterprise Manager on the machine where is the server, I add a linked server with Microsoft Jet driver, everything work good, I can see the tables.

But when I try to see the table from another computer on the same domain with enterprise manager, I get an error like this :

Error 7399 : unspecified error.
[OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005:   ].

Any ideas are welcome, I have tried a lot of things, I get crazy !!

Thanks !


0
krypto2000
Asked:
krypto2000
  • 2
  • 2
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Do you have MDAC installed in that computer (where gives the error)?
0
 
arbertCommented:
How did you setup security on the linked server?
0
 
krypto2000Author Commented:
I have leave the default value... Something like : Execute in the current security context
0
 
krypto2000Author Commented:
And for VMontalvao : Yes MDAC is installed on each computer
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

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