I have an access 2010 database which is linked to a sharepoint list. I have an ASP page which is querying the database and displaying data on a web page. The page auto refreshes every 30 seconds and there are 4 concurrent users.
The users are complaining that the following error is appearing frequently, which is stopping them from using the web page effectively and is preventing them from doing their day job.
Microsoft Access Database Engine error '80004005'
The database has been placed in a state by user '<<username>>' on machine '<<server name>>' that prevents it from being opened or locked.
This has been driving me crazy so any help would be much appreciated!!!