I have a 2003 database that has been split into a front end and backend. The front-end has been copied to all of the users computers and the backend has been saved to a network drive that everyone has full access to.
We have been experiencing the database gets locked to where only on person can get in at one time. It always seemed to happen overnight so we were thinking it was tape backup doing. Once we restored back to the previous day it was fine. We have been running fine for a week or 2 and now it locked during the day.
I had everyone exit and still only one person at time can get in. I dont want to restore back to the previous day cause there was a lot of inputting done today.
Any ideas why this could be happening and how do I resolve it without restoring back to the previous day?
Sincerely,
Rodeoboy