I have created 20 + letters with merge fields populated from an Access database.


I am working with Access and Word 2007.
I have created a form with buttons for each letter, where each button has a hyperlink address pointing to individual letters. Rather than create queries for each letter, I am using querydefs to write queries "on the fly" wheere the button:
Deletes the existing query ("qryResult")
Builds a SQL striing to match the letter parameters.
Creates a new query ("qryResult").

This works perfectly in an XP environment, but in Windows 7 causes the computer to crash. If I go to task manger and kill Access, I am left with the standard prompt, and can open the Word document.

The only work around I can find is to have Word open in the background before I open the database - this sometimes works.

Has anyone any suggestions?

Thanks.