using the same linked table by two apps

Discussion in 'Microsoft Access External Data' started by Alex, Feb 18, 2004.

  1. Alex

    Alex Guest

    I have links with the same Excel table from two Access
    applications.
    When one application uses a query with this table another
    app cannot open a report with the query, which uses the
    same Excel table.
    The error message is as follows:

    The Microsoft Jet database engine cannot open the
    file "Excel table.xls". It is already opened exclusively
    by another user, or you need permission .

    How could I avoid this situation?

    Thanks
     
    Alex, Feb 18, 2004
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Cheow Wang

    Linked Table Manager or Table Properties

    Cheow Wang, Jul 25, 2003, in forum: Microsoft Access External Data
    Replies:
    1
    Views:
    3,630
    Douglas J. Steele
    Jul 25, 2003
  2. Dave Fernandez

    Pivot Table Wizard in Access fails w/ linked table

    Dave Fernandez, Aug 21, 2003, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    547
    Dave Fernandez
    Aug 21, 2003
  3. Tim Heames

    Linked Table Manager does not display linked tables

    Tim Heames, Jan 13, 2004, in forum: Microsoft Access External Data
    Replies:
    2
    Views:
    1,024
    Joan Wild
    Jan 14, 2004
  4. Guest

    How do I convert a linked text file table, into an access table

    Guest, Oct 18, 2005, in forum: Microsoft Access External Data
    Replies:
    2
    Views:
    627
    John Nurick
    Oct 20, 2005
  5. Don

    Linked Table Manager Not Showing List of Linked Tables

    Don, Oct 18, 2005, in forum: Microsoft Access External Data
    Replies:
    4
    Views:
    3,922
  6. Guest

    I cannot modify a linked table in access (linked to excel).

    Guest, Apr 29, 2006, in forum: Microsoft Access External Data
    Replies:
    3
    Views:
    3,579
    Guest
    Apr 30, 2006
  7. Guest

    Linked table Manager; how can I automate changing of the linked ta

    Guest, Jul 7, 2006, in forum: Microsoft Access External Data
    Replies:
    2
    Views:
    773
    Guest
    Jul 7, 2006
  8. Guest

    extracting data from linked db2 table using access make table quer

    Guest, Aug 29, 2006, in forum: Microsoft Access External Data
    Replies:
    0
    Views:
    352
    Guest
    Aug 29, 2006
Loading...