The access database is locked on the server when anpther user accesses it
Posted on 2008-10-20
I have an application using MSAccess on a server and linked access database on each user c:\ drive linked to the common database on the server.
for some users the application is like deadlocked when another user access the same form selected by the first user (only some users not all of them). and the lock is released when the first one closes the form.
The application is working perfectly in tens of my customers sites, and the database is not opened exlusively by the code.
and even on that customer site some of the users do not have this problem. What areas should I look at?
any approach of testing is appreciated.