Very slow opening mail merge document

[Dudley]

I created a command button to open a mail merge document in a backup copy of
my database with code

DoCmd.GoToRecord , , acNext

Dim oApp As Object
Set oApp = CreateObject("Word.Application")
oApp.Visible = True
oApp.Documents.Open "c:\My Documents\Word Documents\......DOC"

(The acNext is to ensure that changes to the record are saved)

This worked fine so I did the same in the active database and Word then read
the records twice very slowly and took an age to open the document. I solved
the problem by creating a new folder for the database, but when I created
another command button to open another document the problem came back. The
fast command is still almost instant and the second is very slow but the only
difference is the document name.

Any suggestions?

Thanks
Dudley

 

[Dudley]

I have found the answer to my problem - just to create a new folder and copy
the database each time I have a problem.

Dudley