using the same linked table by 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
 
Top