I have a form which is used to obtain a value that is used by a query XYZ. The query is in turn used my a mail merge within Word. The query contains details of people. I click a button that opens the word document, which in turn uses data from query XYZ. This worked fine without any problems.
Yesterday I wanted to change the directory that my work was stored in, so I cahnged the VBA code to reflect the new position of the Word document. I then changed the Word document to locate the new position of the database query. Since then I often get the error: -
The database has been placed in a state by user <name> on machine <name> that prevents it from being opened or locked. (Error 3734)
This happens most often when the databse is opened without all the menus etc (i.e. start up tick boxes unchecked). When I open the database using the shift key it works most of the time. Can anyone please help me with this problem?
Thanks very much.