Results 1 to 3 of 3

Thread: Using a linked table in a query

  1. #1
    karen Guest

    Using a linked table in a query

    Error # = 80004005
    Description = [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '\ServernameDatabaseADDRESSES.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = S1000
    NativeError = -1032

    My code:
    MyDb.DbDSN="USARC2000"
    MyDb.DbSQL ="Select * FROM myQuery"

    myQuery has local tables plus a linked table from another database. If I import the table to the current database, there is no error. However, importing the table is not an option. It should remain linked.

    Can I place two DSNs in the code, so that the linked table is recognized?

    Or is there another workaround?

  2. #2
    Frank Guest

    Using a linked table in a query (reply)

    It is exactly like what is says. Somebody is using it like locking it for editing etc. If you try to use ACCESS as a read/write web database, you already lost before you started. Upgrade to SQL or just import a copy of the mdb to your location.


    FK



    ------------
    karen at 4/18/00 10:04:54 AM

    Error # = 80004005
    Description = [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '\ServernameDatabaseADDRESSES.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = S1000
    NativeError = -1032

    My code:
    MyDb.DbDSN="USARC2000"
    MyDb.DbSQL ="Select * FROM myQuery"

    myQuery has local tables plus a linked table from another database. If I import the table to the current database, there is no error. However, importing the table is not an option. It should remain linked.

    Can I place two DSNs in the code, so that the linked table is recognized?

    Or is there another workaround?

  3. #3
    Donna Guest

    Using a linked table in a query (reply)

    Hi Karen,
    You might try upgrading to ADO 2.1. That fixes things like that.
    Good luck.
    Donna


    ------------
    karen at 4/18/00 10:04:54 AM

    Error # = 80004005
    Description = [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '\ServernameDatabaseADDRESSES.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
    Source = Microsoft OLE DB Provider for ODBC Drivers
    SQL State = S1000
    NativeError = -1032

    My code:
    MyDb.DbDSN="USARC2000"
    MyDb.DbSQL ="Select * FROM myQuery"

    myQuery has local tables plus a linked table from another database. If I import the table to the current database, there is no error. However, importing the table is not an option. It should remain linked.

    Can I place two DSNs in the code, so that the linked table is recognized?

    Or is there another workaround?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •