Record-level
locking is a good option when many users are simultaneously editing and updating records. The
only lock contention that occurs in such a situation happens when two users happen to change the
same record at the same time.
Record-level locking is the default in Access 2007. If you choose to use page-level locking, open
the Access Options dialog box (File ??? Access Options ??? Advanced) and deselect the Open
Databases by Using Record-Level Locking check box. In most environments, however, you??™ll find
that record-level locking works just fine.
When you design your applications, the type of database application that you??™re creating should
drive the locking strategy that you apply to your applications. Decision support or EIS-type applications
usually do not need any locks (No Locks or Read-Only access), because most users only
view data and do not change or add new records to the underlying tables. However, if the records
in your application are constantly changing as people add new records or edit existing data, then
your locking strategy will be much more complex.
Pages:
1347
1348
1349
1350
1351
1352
1353
1354
1355
1356
1357
1358
1359
1360
1361
1362
1363
1364
1365
1366
1367
1368
1369
1370
1371