Hi,
I have an access 2010 database which is being populated by data from a sharepoint list. I am using classic asp to query and display data from the database. Now that I have released the application to the users (approx 10 concurrent users), they are getting the error:
Microsoft Access Database Engine error '80004005'
The database has been placed in a state by user <<name>> on machine <<machine name>> that prevents it from being opened or locked.
My connection string is:
strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=<<link to datasource>>;Persist Security Info=False; Mode=Share Deny None"
I have also checked that the database is not being opened in exclusive mode too.
Any ideas on how I can resolve this one?
Thanks in advance!
I have an access 2010 database which is being populated by data from a sharepoint list. I am using classic asp to query and display data from the database. Now that I have released the application to the users (approx 10 concurrent users), they are getting the error:
Microsoft Access Database Engine error '80004005'
The database has been placed in a state by user <<name>> on machine <<machine name>> that prevents it from being opened or locked.
My connection string is:
strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=<<link to datasource>>;Persist Security Info=False; Mode=Share Deny None"
I have also checked that the database is not being opened in exclusive mode too.
Any ideas on how I can resolve this one?
Thanks in advance!