Set up:
I have a front end with the forms and queries and a separate back end with the tables. Each user will have their own copy of the front end and will link it to the back end.
Questions: Can two users be accessing the back end at the same time? If so, can two users access the same record at the same time? If so, how does this work (i.e. can users see the changes live, which one overrides the other, etc.)?