hi
the file path to the access query is hard coded into the sql of the excel
query.
you must change the file path to the new location.
but from my experience and from a number of posts to this forum, changing
the file path in the sql doesn't seem to work as expected. the excel query
still points at the old location.
so i always just delete the old query in excel and create a new query for
the new location.
yeah, i know. sucks. so my best advise is to have someone spank your hands
everytime you get into the mood of moving something.

Regards
FSt1

"Horatio J. Bilge, Jr." wrote:

I used a query in Excel to link to an Access query.
The problem is that when I moved the files to a new folder, I could no
longer refresh the external data (excel was still looking for the *.mdb file
in the old folder). Is it possible to use a relative location for the db
file, instead of an absolute location? It will always be in the same folder
as the excel file.

Thanks,
~ Horatio