Record-Level Locking

A

Andy Calder

I have a database in a multi-user situation (about 10-12
users) and it is set up as a Front-End / Back-end type
split Database. I have been using Optimistic Locking and
sometimes i am getting corruptions to the Database. I
would like to start using Pessimistic locking ( Record-
Level locking). Everyone is using Access 2000 SP 3 and Jet
4.0.
Is Record-Level locking recommended? Is their any VBA code
that would make the locking messages more user-friendly?

Thanks
 

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

Access 2003 application slow when multiple users are on. 9
Record Locking 2
record locking not behaving as expected 4
Why does a record-locking file remain after I close database? 3
Record Locking 3
Record Locking 4
Locking file on Back End of Database 2
Still more on Warning messages 0

Top