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. Tim Heames

    Linked Table Manager does not display linked tables

    Tim Heames, Jan 13, 2004, in forum: Microsoft Access External Data
    Replies:
    2
    Views:
    673
    Joan Wild
    Jan 14, 2004
  2. Don

    Linked Table Manager Not Showing List of Linked Tables

    Don, Oct 18, 2005, in forum: Microsoft Access External Data
    Replies:
    4
    Views:
    2,978
  3. 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:
    2,975
    Guest
    Apr 30, 2006
  4. 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:
    518
    Guest
    Jul 7, 2006
  5. 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:
    288
    Guest
    Aug 29, 2006
Loading...

Share This Page