Parameter Query with Mail Merge

[johnbowser11]

I have a database on a machine with office xp. I store the database in C:\Database.
I can run a query then link the results of that query to a template document I have setup via mail merge. The document then opens and fills out the fields based on the query results.
I transferred the database onto another machine with office 2003 and put it in exactly the same directory c:\database. and when i try to link the query to word, word just comes up saying it cant find the source.
I have gone around various machines at work and the merge runs fine on all machines with office xp and not with 2003.

Any Ideas?

 

[johnbowser11]

If you open the word document on its own the merge works fine, it open up access, runs the query and then fill out the merge.