Problems merges into Word97 from Access 97

  Blott 11:32 20 Oct 2004

I have several documents which merge from Acess Database into Word97, using word templates ( *.dot files).

All goes well, and the Template sets up a document which meges well and I then "save as" as a *.doc file.

OK so far. However, the problem arises when I come to re-open the saved document :- I am then asked for the database password. If I then click on cancel, the document eventually opens, after a warning that DDE connection with the database could not be made.
When I come to close it I am asked if I wish to save changes to the Template ( *.dot).

If I click "yes" on that the connection between the Template and the database is lost, and next time I merge I have to go through the rigmarole of re-connecting.

This is a major inconvenience for me but is a real problem to anyone to whom I want to e-mail the merged document. Most recipients are unaware of the difficulty and say they cannot open the document.

Is there any way of completely severing the connection between the database and the merges document when it is saved, without severing the connection between the template and the database ??

Any help appreciated.

Regards to all

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 6 review

Razer's Core X GPU enclosure hands on review: It's cheaper, bigger, and even works with Macs

MacBook Pro keyboard issues and other problems

E3 2018 : dates, conférences de presse, billets et plus