The database engine could not lock table as already open by anoth.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am currently using a command button on a form in Access 2003 that is linked
to a parameter query which makes a mailmerge table before selecting the data
to populate to a word document. The operation works on the first attempt but
when I re attempt the process I receive the following message 'The database
engine could not lock 'table' as already open by another user or process'.
Help!
 
I am currently using a command button on a form in Access 2003 that is
linked to a parameter query which makes a mailmerge table before
selecting the data to populate to a word document. The operation
works on the first attempt but when I re attempt the process I receive
the following message 'The database engine could not lock 'table' as
already open by another user or process'. Help!
Click to expand...

I'm not sure if this will help but try
DBEngine.Idle dbFreeLocks
after query

Bob
 
Back
Top