Linked server from SQL Server to Access db on network share?

From: Hobbes (anonymous_at_discussions.microsoft.com)
Date: 02/19/04

  • Next message: DB_Princess: "RE: spontaneously made login" 
    Date: Thu, 19 Feb 2004 12:26:42 -0800

    I have an Access database that exists on a network share
    that I'm trying to link to as a linked server from SQL
    Server. Sitting at the SQL server machine, I can create
    the linked server (both by EM and sql), connect to the
    access db, query data, see tables, etc with no problems.
    However, if I go to another machine and try to access the
    linked database, either through EM or through sql, I get
    this error message:

    Server: Msg 7399, Level 16, State 1, Procedure
    sp_tables_ex, Line 20
    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\path\database.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: ].

    The SQL server service is running as a domain user with
    full access to the network share.

    Any help?

  • Next message: DB_Princess: "RE: spontaneously made login"

    Relevant Pages

    • RE: Backups have Shadow Copy Problems
      ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
      (microsoft.public.windows.server.sbs)
    • Re: upsizing to sql 2005
      ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
      (microsoft.public.access.queries)
    • Re: Linked Tables in Access
      ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
      (microsoft.public.access.adp.sqlserver)
    • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
      ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
      (microsoft.public.sqlserver.msde)
    • Re: Leveling by ID vs. "Standard"
      ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
      (microsoft.public.project)