Security/permissions problem

[Guru]

Running on XP

My asp access a local Access 97 database. I have set the security settings to allow read+write access for IUSR etc and it works fine.

I have VB app located on a different PC which updates the database.

So far, so good.

One the VB app has accessed the database, the asp can't. If I open the security setting properties for the database and just unset and the reset one of the checkboxes and click apply it then works OK.

Why is this happening?

I am opening the database in the vb app thus:

Dim cnn As New ADODB.Connection
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & database & ";"

and in the asp:


set Conn = Server.CreateObject("ADODB.Connection")

Conn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\Inetpub\wwwroot\abc\db2.mdb")


Not sure if that has anything to do with it...

Thanks

[adocwra]

<%
Dim ConnectString, conn

ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db.mdb") & ";Persist Security Info=False;"


Set conn = Server.CreateObject("ADODB.Connection")
conn.open ConnectString
%>
try this