Record Locking in Access 2000 DB

  • Thread starter swap m via AccessMonster.com
  • 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.
 
M

Michel Walsh

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
 
Top