Connection String suggestions

[SirPoonga]

I am trying to find teh right connection string. I am using MS Access
with a ASP.NET application. My current connection string is:
Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\location\my.mdb

If I have the db open and try to run my asp app I get a file in use
error.
I tried adding "Mode=Read;" but then I get a could not lock file error.
Any ideas?

 

[Sergey Poberezovskiy]

Try
Mode=Share Deny None;

HTH

 

[Douglas J. Steele]

Take a look at Carl Prothman's http://www.able-consulting.com/ado_conn.htm

In addition, are you sure that the ID under which the ASP.Net application is
running has the necessary permissions on the folder where the MDB file
exists? I know with ASP applications, this was often a problem. In the case
of ASP applications, the ID was usually IUSR_xxxx, where xxxx is the machine
name. It requires Change access (Read, Write, Delete, Execute) on the folder
where the MDB file is located.

 

[SirPoonga]

Ahhh yes. That's it. Needed to add the user ASPNET to the permissions
list. Thanks.

It's odd though. The ASP app could connect to the DB as long as it was
the only one using it. If I opened it through access and then tried
using the asp page it would create the error.