I have a split database. The back-end file is on a server. The front-end file is on every user's computer and is linked to the back-end.
If user #1 has a record open via a form and user #2 tries to even open the database they get a message indicating that the BACKEND file is in use. Then the main menu opens but they can't go to any record.
Why would this be happening?