I have a windows application on VB.Net and I connect it to a MS Access database placed on a server. This application is multiuser (50 users aprox reading and writing data), all of them can access the application at the same time with no problem.
This application works Fine but my problem is that the Database gets locked by an user (not the same all the time) at some point. The application can work for several days with no problem, then some day it shows to the user the error that it can not write data to the database.
When this happens I try to open the MSAccess database directly and it tells me that I can only open it as read-only.
To fix this problem I have to close the user's connections to the database (ldb file) on the server, then everything goes normal again.
Can anyone help me with this error? Does anyone has experienced this problem before?
Thank you for your time.