Writing to ACCESS created databases using ASP and Jet.

[Guest]

It seems that the the latest security fix to JET 4.0 has prevented me from
doing INSERT or UPDATE
I am using the example from the ADO tutorial by w3schools at
http://www.w3schools.com/ado/ado_add.asp
But when I try it on my own database I get "No ..... permissions"
I cannot find out what permissions I should set and where - please can
someone help?
My setup in ASP is
Set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "C:\c\r\creationsoftware\private\registration.mdb"
I have done nothing special for security when I created the database.

 

[Douglas J. Steele]

If you're using ASP, the ID under which the code is running (usually
IUSR_<machine name>, where you need to replace <machine name> with the name
of the machine) must have Change access (Read, Write, eXecute and Delete) to
the folder where the MDB file exists.

 

[Guest]

Thanks for you response - this leads to some questions.
1. Where do I find the ID and
2. This will be unstalled in another server - How do I ensure that the setup
on the server is correct. I am new to Access and ASP.
3. Can I give an ID on the ASP conn.Open and setup the ID in the database?
Again thanks
Dennis

If you're using ASP, the ID under which the code is running (usually
IUSR_<machine name>, where you need to replace <machine name> with the name
of the machine) must have Change access (Read, Write, eXecute and Delete) to
the folder where the MDB file exists.

 

[Douglas J. Steele]

Answers in-line


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Thanks for you response - this leads to some questions.
1. Where do I find the ID and

Assuming you know the name of the machine, you should be able to figure out
the ID.

2. This will be unstalled in another server - How do I ensure that the
setup
on the server is correct. I am new to Access and ASP.

Is there a system administrator you can ask for help? If not, then you'll
have to do the same thing on both servers.

3. Can I give an ID on the ASP conn.Open and setup the ID in the database?

I don't believe so.

 

[Guest]

I have a reference to adding userid to IUSR_<machine-name> to the .mdb root
folder and have set this up but I still get the error indicating I do not
have the permission to use UPDATE from ASP/ADO. I can READ OK. Am I missing
something?