Record Locking in Access 2000 DB

  • Thread starter Thread starter swap m via AccessMonster.com
  • Start date Start date
S

swap m via AccessMonster.com

Hi all,
I have seen in so many articles that record locking is not possible in
MS-Access, but we can achieve it by making the size of each record to 1024
bytes(Let us say this is the record locking limit size).
I want to know if there is any setting in the DB that sets the record
locking limit size.
Thanks,
Swapna.
 
Hi,


The latest Access versions (those based on JET 4.0) allows record locking,
you should have outdated articles, or listening to "self proclaimed Access
experts" ...

It is on by default (in these versions, since Access 2000 if memory serves)
and to turn it OFF, you can go to Tools | Options ... tab [Advanced], there
is a check box "Open databases using record-level locking". Uncheck it to
turn OFF record level locking.


Hoping it may help,
Vanderghast, Access MVP
 

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

Tools for record locking 9
Tools for record locking 1
Tools for record locking 1
Record-Locking remains open after closing 0
Access Clear all records in access 2
Update fields based on concatenate 2
Record Locking 2
Record Locked errors when updating to same value 2

Back
Top