Query source location - how do I change?

  • Thread starter Thread starter Jennifer Crawford
  • Start date Start date
J

Jennifer Crawford

I have set up an Excel worksheet so that it pulls data
from an Access database when the user fills out two cells.

When I distribute this worksheet, the location for the
Access database will have changed.

Is there a way for me to somehow programatically update
the location for the Query source (database) without
having to manually go recreate the query to point to the
new source?

Thanks!

Jennifer Crawford
 
Back
Top