DB corruption due to same set of records being edited

[achau]

I have an Access DB that is split into frontend and backend, with backend being the Jet DB. If two users open the same rows of records in a form but actually edit different records (ie records 1-20 are displayed on both users' PCs, but person A only edits records 1-5 and person B only edits records 12-16), would this cause corruption to the database when the records are saved? If so, would all subsequent records in the data table get "deleted"?

Anyone has encountered similar problem before? Any solutions apart from changing the process so that no two users will open the same subset of data simultaneously?

Al

 

[BBaggins]

No, the database will normally not be corrupted by multiple users updating the same table or even the same record within a table. Jet's locking mechanism prevents that from happening.

You will, however, get trappable errors if two users attempt to update the same page at the same time.

Just make sure you trap the standard concurrency errors (3158, 3186, 3187, 3188, 3260, 3008, 3197, 3261, 3262), and write a routine to retry failed queries after waiting a random period of time.