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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
locked table error 4
Access Error - The Microsoft Access database engine could not find the object 'Databases' 0
Database engine can't lock a table 2
Cant open database. Error: "could not find the object 'databases' 1
Linking a Form to another Form Problem 1
The database engine could not lock table "..." because it is already in use (3211) 0
I get error message: Database engine not able to lock table 1

Back
Top