If data integrity is one of your top five objectives, stop using Microsoft Access for a web database immediately. Move to something that is up to the task such as SQL Server or MySQL. This is especially true when you are concerned about things like record locking, etc.
Access is great for tracking your baseball card collection, but multi-user applications over the web are a disaster waiting to happen.
Thank you for the reply. I was fearing that the question would go unanswered.
I appreciate what you are saying, but I am dealing with an existing database that is used by multiple web programs. At the present time I am stuck with Access because of this.
I agreed with tclaremont's suggestion about moving to enterprise level database system. I also understand your situation because it happened to me before.
I'm not an expert in Access, but adding STATUS field would do the job.