Record Locking

Hi Bob

Record Locking in tables takes place whenever someone access a record in a table

This prevents the situation where two users log onto the database, access the same record and begin to change it. This would corrupt the data.

Access uses a database engine (Jet) to avoid data corruption caused by simultaneous updates.

The database engine imposes locks on records as they're edited. A lock notifies the engine that someone is editing the record. It's up to the database engine to appropriately respond to the lock, which prevents data corruption.

So when a user access a record, Jet creates the .LDB file and makes entries in the LDB notifying other copies of Jet of the user's activities.

Hope this helps

Carlos