19. Performing Advanced Data Operations
Coding for Concurrency
Access was designed from the ground up as a multiuser database. That means that two or more users can have the same Access database open at the same time, and nothing bad will happen. This is true from the Access user interface, and it’s also true from the code that you write to automate Access.
The key issue in multiuser database use is that of concurrency: what happens when two database users try to edit the same record in the database at the same time? This section briefly reviews the way that concurrency works in Access, and then shows you how to handle these issues in your ADO ...