Using Office 2003.
Is there a way to use a macro to update query data source links when the
path to the data source changes?

I created a spreadsheet and use MS Query to get data from a Access database.
All works well.

I move the spreadsheet to another computer that uses a different path to the
Access database and the query fails because it can't find the database - the
dialog that pops up is entitled "MS Access driver LogIn Failed" and the
error text is "Cannot find the file C:\test\testdata.mdb" Locating the
access database in the login dialog that pops up next does not resolve the
issue.

I can manually recreate the query but is seems like I should be able to
store the path to the database in a cell and use a macro to recreate
everything.