Query on a linked spreadsheet

#1 July 8th, 2004, 11:34 PM

In Access, I have linked an Excel spreadsheet, and then
have queries running off that linked spreasheet. The
queries are functioning correctly, but when I have a
query running, I can no longer open the spreadsheet. If
the spreadsheet is already open, I can't save any of my
changes until I close the query. The spreadsheet is
shared, allowing changes by multiple users.

Is there any way to run a query and still be able to
open/save changes to the spreadsheet that is linked?

#2 July 9th, 2004, 01:16 AM

see reply in other newsgroup in which you posted this message.

--

Ken Snell
MS ACCESS MVP

"Michelle" wrote in message
...
In Access, I have linked an Excel spreadsheet, and then
have queries running off that linked spreasheet. The
queries are functioning correctly, but when I have a
query running, I can no longer open the spreadsheet. If
the spreadsheet is already open, I can't save any of my
changes until I close the query. The spreadsheet is
shared, allowing changes by multiple users.

Is there any way to run a query and still be able to
open/save changes to the spreadsheet that is linked?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hidden files in Ms-Query cause ODBC connect errors or Query is wac	needyourhelp	General Discussion	4	July 12th, 2004 09:38 PM
Linked Spreadsheet	Glenn Robertson	Worksheet Functions	1	December 16th, 2003 08:42 AM
multi-user lockout of linked excel spreadsheet	Tim Schiermeyer	Setting up and Configuration	0	November 15th, 2003 01:56 AM
multi-user lockout of linked excel spreadsheet	Tim Schiermeyer	Links and Linking	0	November 15th, 2003 01:56 AM