Home Forums SQL Server 7,2000 Administration Linked server to MS Access... RE: Linked server to MS Access...

  • May 26, 2005 at 12:08 am

    #561130

    Thank you for a reply, but it doesn't work. On EM I get the same error as earlier:

    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: ].

     
    Trying to execute select statement through QA I get the following:
     
    Server: Msg 7399, Level 16, State 1, Line 1

    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 '\\server\user\Corp\MS.mdb'.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:   ].

     
    I checked the following KB about error 7399, but it didn't helped

    http://support.microsoft.com/default.aspx?scid=kb;en-us;814398

    I remember we had the same issue with linked sql servers, but we solved that by entering some values in provider string on the linked server like: server name, uid, pwd and network. But on access linked server I cann't find any parameters to enter that 'provider string'

     

    Any ideas?