error 3211

  • Thread starter Thread starter Harmannus
  • Start date Start date
H

Harmannus

Hallo,

I get a error 3211 when printing a report. Serveral other report do not have
this problem.

How can i get arround this error?

The code stops and the debugger tells me "Run-time error '3211': The
database engine could not lock 'tbl<name>' because it is already in use by
another person or process."

Thanx for any assistance


regards,
Harmannus
 
Do you have any form open at the time that could have uncommitted edits? If
so try closing the form, or at least saving the record before opening the
report.

It could also be a recordset you have open in code, or a query you have open
in the background.

If nothing is open, try closing Access completely. Open the Windows Explorer
to the folder where the mdb file is. If you see an ldb file there with the
same name, delete the ldb file. This contains locking information, and
Access generally deletes it when it exits the database. However, if the
computer crashes, the ldb can contain spurious locking information.

If none of these work, it may be a corruption. Post back a reply to this
thread for further specific instructions, or for generic suggestions visit:
http://members.iinet.net.au/~allenbrowne/ser-47.html
 
Back
Top