MS Access multi user support has stopped working
Posted on 2011-10-17
My company has several older Access databases which are stored on file servers where multiple employees access them simultaneously. This has worked for many years and has recently stopped working for two databases.
The databases are on separate servers and used by separate groups of employees. The employees have shortcuts on their desktops to the mdb files on mapped network drives. When the first employee opens the database it works fine, when additional users try to open it they double click on the shortcut and briefly get an hourglass then nothing else happens.
I have tried copying the file to the local computer and after doing so they have no problems opening it from the local disk. I have also tried getting everyone out of the database and once everyone is out, an employee who could previously not access it can not access it with no problems.
So it would appear that the first user is somehow locking the database and preventing anyone else from using it. As soon as they close the database someone else can open it. We have not made any configuration changes, so I am suspecting some sort of windows update or perhaps some other type of update could be causing this problem.
Employees are using MS Access 2003 on a combination of Windows XP SP3 and Windows 7 x64 SP1. The servers are a mix of Windows 2003 and Windows 2008.
Do you have any suggestions?