using the same linked table by two apps
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Date: Wed, 18 Feb 2004 14:55:33 -0800
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
Relevant Pages
- Re: OutputTo to Excel question
... Excel file and opening up ... clicks Ok and your query is exported) ... If Macro is going to keep on giving the format error problem, ... Save a query that pulls the same data as the report. ...
(microsoft.public.access.macros) - RE: Help with Queries
... the VLOOKUP function allows you to put a single 'Report Month' input cell at ... return data column number by the VLOOKUP function. ... You could use a query, called a QueryTable in Excel. ...
(microsoft.public.excel.worksheet.functions) - RE: Help with Queries
... I've lost my posts before too... ... the VLOOKUP function allows you to put a single 'Report Month' input cell at ... You could use a query, called a QueryTable in Excel. ...
(microsoft.public.excel.worksheet.functions) - Re: Exporting to Excel - retaining number format
... I assume that you're using a query as the report's Record Source. ... You may or may not need to put a control on the report that is ... bound to this calculated field -- quite honestly, I don't use the export to ... EXCEL option because it doesn't provide me with any benefits/use, ...
(microsoft.public.access.reports) - RE: Macro
... Then post the query results. ... My data is in an Excel file called ... Microsoft SQL Server 2000, which requires a server, VBA or Microsoft Query ... VBA code in excel suddenly became un-compileable. ...
(microsoft.public.excel.programming) |
|
