I have an Access Database that I create several queries to merge with
multiple Word Documents. I have an new issue that just starting
hapening with Access 2003 and Word 2003. I also have this on on
another server with Access XP and Word XP. When I run my code and it
opens the Word Document it merges the document with the query; however
when I run it on the Server with Access 2003 and Word 2003 the doument
opens but I have to setup the datasource all over again. I used to
just open the Word Doument (2003) and tell it it is OK to run the SQL
script save it and then go back into Access and it works, but now this
is not happening. The Database and Documents are a copy of what is on
the other server. Both servers are Windows Server 2003 SP2, the only
difference is one has Office XP, the one that works and the one that
does not work has Office 2003. I do not think this has anything to do
with my code as it was working until I copied some new douments up to
the Office 2003 server. Is there a setting in Word that I need to
look for?
TIA,
Rodger