Here's the scenario:

I have a Word document set up to be a mail merge with the data coming from
an Access database.

In this same Access database, I have a form with a command button on it that
opens this Word document.  The Word document has an AutoOpen macro that
automatically sends the merge to a printer and then closes Word so that I
can return to the form.

It works well except I get the following message:

The database has been placed in a state by user ** on machine ** that
prevents it from being opened or locked.

It prints the Word file and then it closes my Access database.

I'm assuming it does this because the data is coming from the same database
that I already have open.  Do I need to open another session of Access in
order for this to work properly?  If so, it sounds like this would take a
lot of memory with Word open and 2 sessions of Access and anything else the
user might have open.  Or does anyone have any suggestions on how to get
this work?  It works like a charm except for closing my database -- which
isn't very charming.

Thanks in advance for any help.

Debbie Grabb

             Do you want to signoff PCSOFT or just change to
                    Digest mode - visit our web site:
                   http://freepctech.com/pcsoft.shtml