View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Horatio J. Bilge, Jr. Horatio J. Bilge, Jr. is offline
external usenet poster
 
Posts: 135
Default Use relative address for database query

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