Hi Jerry

MSQuery has a habit of embedding file names in the SQL for the query
which makes relocation of the database a problem.

Assuming your email address is a valid way to contact you I will email
you a workbook containing a small macro which you can use to change the
connection and source properties of any query tables in your workbook.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup