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
Dynamic Naming of Form Button 3
DDL Query And Error 3211 2
Run-Time error '3211' 0
Run Time Error 3211 0
VBA Coding Help for Beginner 0
Error 3211- The database engine could not lock table 5
6ooo old Emails dumped into Inbox of Outlook 2007 on Xp Pc 0

Top