Problem with Linked server to MS Access database

Posted on 2005-05-04
Last Modified: 2010-03-19

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 !

Question by:krypto2000
    LVL 44

    Expert Comment

    by:Vitor Montalvão
    Do you have MDAC installed in that computer (where gives the error)?
    LVL 34

    Expert Comment

    How did you setup security on the linked server?

    Author Comment

    I have leave the default value... Something like : Execute in the current security context

    Author Comment

    And for VMontalvao : Yes MDAC is installed on each computer
    LVL 44

    Accepted Solution


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now