Runtime error 3211

D

Diogo

OK people I get this message:

"The database engine could not lock table 'Tabel XXX' because it is already
in use by another person or process"

This would all be fine if I had not split the database into front-end and
back-end, to allow multiple useres to write to the same table at the same
time...

Among other features I belive that is what spliting a database is for... or
am I wrong???

Could someone shed some light? I realy need multiple simultaneos users to be
able to write to the same table.
 
A

Alex Dybenko

Hi,
to split database is always a good idea for multiuser environment, but looks
like you have a locking issue. Check Record Locks property of opened forms,
normally it should be "No Locks" there, unless you really require this

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 

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

Error 3211 delete table with multi-valued lookup field 7
Run time error 3211 5
error 3211 1
Error 3211- The database engine could not lock table 5
How can I reset a database if Run|Reset doesn't work? 1
Access access 2007 - error 3211 - locked table 0
data base connection runtime error 3211 1
The database engine could not lock table "..." because it is already in use (3211) 0

Top