I am a real newby at this so forgive me if I don't give the right information, but here is my problem:
I've created a shared MS Access database for my clinic, which we use for patient check in. At some times it is used by up to 20 people at a time. Intermittently, the file will become locked by an "Admin" and it will list which computer they are working from. The file is not split (I just learned about that), but I know it is set to be a shared file and it is saved on a shared network drive. The computer that becomes the "Admin" is not the first to open the db. Those that are already logged in are not affected by the lock, but anyone else that tries to open it after the fact are not able to get in. Sometimes the problem sporadically solves itself, and sometimes we have to exit the program on the "admin" computer and then reopen. Then everyone is able to get in. The times I've been able to find the "admin" computer that is taking exclusive access, the user is simply on the DB making their changes and using it as usual, which should not cause it to be locking up like that. HELP!