Security/permissions problem
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
Re: Security/permissions problem
<%
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