Hi Bill,
MS Access prevents multiple users from modifying the same record within a
Microsoft Access database. This is achieved within Microsoft Access by the
use of locks on the database. Microsoft Access implements a page-based
database. It is these pages that are locked when a record is edited. When a
given record is locked, the page that contains the record is in fact locked,
thereby locking all other records that also reside within the same page.
This is in your own interest..... data concurrency ensures that there is no
redundancy or mess in your tables.
In my opinion, this is a desired feature in any database, and should not be
avoided. If more than one users are modifying the same data at the same
time, and there is no locking, the whole database would be screwed up.
You can look for certain permissions to your users, like read permissions to
all, and write to certain users at certain times.
Also, you may want to go through the Access database storage process in
detail.. here is the link:
[Database Optimization Techniques]
http://msdn.microsoft.com/archive/d...v/html/ODC_DatabaseOptimizationTechniques.asp
The .ldb file in the Access database also plays an important role in the
multiuser scheme. It is used to determine which records are locked in a
shared database and by whom.
[Introduction to .ldb files in Access 2000]
http://support.microsoft.com/default.aspx?scid=kb;en-us;208778
Hope this helps.
Anushi
