I have an Access application that opens up one of 20 different Mail Merge letters. No issues on the Access side. When the Word document opens I get the usual SQL warning, but sometimes i get a second warning with a different (maybe temporary and without a path) filename. I am using RTF files for the merge data. See the examples below.
First (and normal) Warning
Code:
Opening this document will run the following SQL command:
SELECT * FROM T:\FITS_2007\Leters\MailMerge\qry_Not_Enough_Info_R.rtf
Data from your database will be paced in the document. Do you want to continue?
2nd Warning
Code:
Opening this document will run the following SQL command:
SELECT * FROM A065428D.rtf
Data from your database will be paced in the document. Do you want to continue?
From here the document seems to merge correctly with the right data, but I'm concerned that the user may inadvertantly save the Word document while it is pointing at this temp file which will not get updated going forward. So I am wondering why this is happening and how can I prevent it from happening in the future.
Any ideas?