Its purely a development issue. I am having to develop the system using a
live Excel worksheet. So have taken a copy of database and sheet, i then
do work on it, and copy it back to the network so that users can use it. I
then have to keep changing the query definitions so that the users can use
the data during the day.

Once development is finished, wont be an issue, but its quite a long
process. then i got to wondering why, if I changed the query connection
using the Edit function, the worksheet would not connect to the network
version of the database, unless i recreated all of the queries.

A



"Kevin B" wrote in message
...
Yeah, it would replicate your data and you would have to use another
worksheet for the local version of your query.

Why are you moving the database to your C drive in the first place, is it
a
performance issue? Just curious...

--
Kevin Backmann


"Alexey" wrote:

Does that not mean that I will have the data in the worksheet twice?

A