Record Locking

6

'69 Camaro

Hi, Samuel.
Can the lack of record locking increase the chance of file corruption?
Click to expand...

Jet always uses either record locking or page locking when the database is
open, unless the database is opened exclusively. But even then it's a
complete database lock instead of the individual rows or data pages, so the
data integrity is protected. If you open the database with, say, a hex
editor and make data changes, you'll likely have file corruption if you
aren't very, very careful.

Therefore, by using Jet (or a driver that interfaces with Jet), you're
getting an effective locking method to protect the data against corruption,
but not necessarily at the record level. Any other usage of the database
file could easily result in corruption.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Top