Main issue is handling errors that occur when locks are placed on pages of records. The following considerations are important:
-
Balance network security and maintenance against efficiency and speed when choosing to install Access on each workstation.
-
Balance ease of use, data integrity, and ease of programming in developing the locking strategy.
-
Awareness of errors that can occur when multiple users share data.
-
Use custom error-handling code when using bound forms with optimistic locking.
-
Use custom lock notification code when using bound forms with pessimistic locking.
-
Splitting database into separate data and application databases for increased performance.
-
Using VBA code to manage the linked tables in a split database structure.
|
