I have a database that was working fine compiled. The db is split into front end and back end. Recently, the back end has been corrupting, requiring us to perform a repair. This happens when more than 5 users start working on it.
I decided to run the db's uncompiled and have no problems, with multiple users. We are running the front-ends from a network share using a shortcut. I have also tried it by having a local copy of the front end. Either way, after more than 5 users start working on the system, the back end corrupts, when someone exits and comes back into the database.
I have noticed that the locks file doesn't seem to be working like I would expect. I recall that when you opened the lock file (or a copy) when the Db is open, it used to list all the users in the db. Now it only seems to list the last user to open the db. Is this normal behavior?
All of the computers are running 32 bit Windows 7 and Office 2010.
Any suggestions for how to get the compiled version working again. My thought is perhaps an office/windows update has somehow broken this feature from working.