I have a serious problem using MS Access. I developed an application that will be running in various PCs and will access the database placed in a server, and this application has a refresh system, every 5 secs it searches data in the db to refresh the status in the main form... The proble is that when more then one PC is running the application it starts to give me this error, and the bigger is the number of PCs accessing the DB the most frequent become the error, making the use of the software almost impossible.
Error: The database has been placed ina a state by user 'UserName' on machine 'ComputerName' that prevents it from being opened or locked.
Searching about that error i've noticed that it is something tha usually happens when many PCs try to access a DB from MSAccess simultaneously.
What I've tryed and didn't work:
-Configured the DB to Shared and removed any locks in the MSAccess.
-Checked if every connection opened with the DB was properly cosed (con.Close()).
I hope you can help me...