Ok, so I am not very knowledgeable about access, and its intricacies, but we have an issue that is very frustrating. I wasn't 100% sure how to title it.
We have a database that is set up so that if a user is in a record, the record is supposed to open a read only copy for the 2nd person that...