I created a database in Access 2000 and set up user-level security using the wizard. All users have at least read access to all objects. I also have an MS Word mail merge set up linking to a query in the database. The code in Access opens the main merge document, and a code module in the document performs the merge and displays the print preview. The merge document opens a second instance of the database in order to link to the query.

Here’s what happens:

I log on to the database as any user, (doesn’t make a difference which one) and select the report to run the merge. Word opens and displays an error that I do not have appropriate permissions. I click “OK” and it goes ahead and performs the merge.

Next, I log on to the database as an Admin user and view the user and group permissions. For each group, I remove and immediately re-apply the read access.

Now, I can close the database, log in as any user and run the merge as before with no error -- until I reboot the PC; then the error comes back as before.

Anyone have any ideas on how I can keep the error message away?