Access 2010 error when accessing using ASP

[sidj]

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!

 

[ChrisHirst]

Data Source=<<link to datasource>> Needs to be a physical path to the file. Use Server.MapPath(Root relative path) to convert it.



Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[sidj]

The link to the database is a physical path. Any other ideas?

 

[MakeItSo]

Permission issue?
Do the users have write permission on the folder the db is stored in?

“Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family.” (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.

 

[xwb]

Try the following from the command line on the server (I'm assuming XP)

cacls dbname.mdb /E /G everyone:C

On W7, this has been replaced by icacls. Parameters may be different.