See also locked records; record-lock error
handling
All Records setting, 700
built-in features for, 699??“702
Default Open Mode setting, 701
Edited Record setting (pessimistic locking), 700??“701
multiuser application issues, 698??“702
No Locks setting (optimistic locking), 700
Number of Update Retries setting, 701
ODBC Refresh Interval setting, 702
overview, 698??“699
page locking versus, 699
Refresh Interval setting, 701??“702
Update Retry Interval setting, 701
Record Locks property
of forms, 289
of queries, 590
Record Selectors form property, 284, 285, 642
record source, changing for corrupt forms, 857
Record Source property
of forms, 251, 282, 288
of reports, 658??“659, 665
record-lock error handling
for Error 3021, 704
for Error 3186, 704, 709??“711
for Error 3188, 711??“712
for Error 3197, 704??“705, 712??“714
for Error 3260, 705??“709
for Error 3421, 705
ErrorRoutine() function for, 703??“705
need for, 702??“703
for optimistic record locking, 704, 709??“711, 712??“714
for pessimistic record locking, 705??“709
records or rows
adding to datasheets, 21, 85, 208??“210
adding using ADO, 490??“491
adding using append queries, 609, 610??“611, 613??“614
bookmarks for locating, 867??“869
changing display height in datasheets, 224??“225
in datasheets, 205
deleting, checking status after, 489??“490
deleting from datasheets, 217
deleting from tables, 42
deleting related records in multiple tables, 492??“495
deleting using ADO, 491??“492
described, 5, 6
duplicates, finding, 601??“603
entity integrity for, 72, 110
event procedure confirming deletion, 434??“435
fields in, 205
finding first (n) in query, 585??“586
finding number in table or query, 585
FindRecord method for, 848, 865??“867
grouping by field value, 841
1338
Index Q
hiding in datasheets, 225
moving between, in datasheets, 214
moving between, in forms, 273
order of adding to tables, 75??“76
orphaned, finding, 603??“604
pointers in datasheets, 210
printing from datasheets, 233??“235
recalculating fields after deleting, 489??“490
recalculating fields after updating or adding, 486??“488
saving, 210, 229, 279
unmatched, finding, 601, 603??“604
updating fields using ADO, 481??“486
Recordset data type (ADO and DAO), 483, 484
Recordset object (ADO).
Pages:
2401
2402
2403
2404
2405
2406
2407
2408
2409
2410
2411
2412
2413
2414
2415
2416
2417
2418
2419
2420
2421
2422
2423
2424
2425