Developing Multiuser Applications
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.