Problem with Linked server to MS Access database
Posted on 2005-05-04
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 !!