Why not maintain 2 sets of queries, one for the F drive and the other for you
local C drive?
--
Kevin Backmann


"Alexey" wrote:

Hi, hope this is the right forum to post this.

i need to bring in data from some data that is held within queries in an
Access database file.

There will be about six lots of data,. In Excel i have set up the first
one using New Database Query. the data has come in OK.

The database and the Excel worksheet are held in the same folder on our
network drive designated drive F.

However if i move the database and Excel worksheet to my local drive C: and
run it, I get an error that the data cannot update. If I edit the query, i
can see that it is looking for the data on my drive F. I have changed this
to drive C, but when i run I still get the sdame error message.

Is there a way to set this up so that it can be moved between my local drive
and our network easily, without having to rrecreate the Excel queries every
time?

thanks

A