I am working on revamping the database at the company I work at. I've been making decent progress getting various parts set up, but something occurred to me today that I hadn't really thought to consider as a variable for my setup.
With this database, there is the potential for there to be multiple users accessing it at the same time. Now it isn't an insane amount, like 50 different users all going at it at once. Rather the situation is closer to their being 2 or 3 users that can be assumed to be accessing the database at the same time.
Now each of these users would potentially be Updating, Adding, or Deleting records within the database. As such I am concerned about potential problems arising from a situation like the following:
Employee A begins editing a record
Employee B deletes the record Employee A is current editing
Employee A goes to commit changes, but the record no longer exists
So what are some ways I can set up the database to get around issues like this? Each person will be logged in to the database on an account, so I can track who is online and potentially making changes. What is some recommended reading any of you would have for a situation like this?
