using the same linked table by two apps

Alex

Guest

Posts: n/a

18th Feb 2004

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

« How to create a macro (or a vba sub) to export the result of a query to a csv file | importing from Outlook to Access or vice versa »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help updating table from linked table(linked table is a csv)	Thierry	Microsoft Access Queries	2	29th Jun 2004 02:21 PM
queries for the same linked table from two apps	Alex	Microsoft Access Queries	0	19th Feb 2004 12:48 AM
UDP Listen on same port by two apps at same time	mBird	Microsoft C# .NET	9	9th Dec 2003 04:46 PM
UPDATE a linked access table with value from a ODBC linked SQL table	JB	Microsoft Access	0	18th Nov 2003 10:27 PM