queries for the same linked table from two apps

A

Alex

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
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

You'll need a new app to open this about link 1
using the same linked table by two apps 0
query to show where no data in a stated column 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
query links to SQL server and mdb table 1
Showing two 'counts' on the same row 4
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0

Top