Permissions error on insert into Access 1

[brad1978]

Hi everyone,
I have a bit of a problem with an application I'm working on. I am submitting information to an access database and keep recieving this error "2147217900" which, from googling it, seems to be a permissions error on the access database. I have gone in and reset the permissions for the IUSR-XXXXX account to full control but still recieve this error. Can anyone help me clear this up?

dim CONN, RS, SQL
SET CONN = server.CreateObject("ADODB.Connection")
CONN.Provider = "Microsoft.Jet.OLEDB.4.0"
CONN.Open = "C:\inetpub\[URL unfurl="true"]wwwroot\asp_test\blog\blog.mdb"[/URL]


SQL = "INSERT INTO replies ([R_Blog_id], [R_postby], [R_posttime], [R_comments]) values ('"& R_Blog_id&"','"&R_postby&"','"&R_posttime&"','"&R_comments&"');"

on error resume next
CONN.Execute SQL', recaffected
if err<>0 then
  Response.Write("No update permissions!" & err)
else
  Response.Write("<h3>record added</h3>")
  response.Write("<p><a href='bloglist.asp'>Click to go back</a>")
end if
conn.close

 

[aarellano]

look at the permision for the actual access db right click on the file.mbd and click on properties, click on security assign the permissions there

Hope this helps

 

[vicvirk]

another method is to place ALL of your databases in a separate folder and give that folder + all children (files/subfolders) access.

This way, you'll never need to worry about setting individual access restrictions.

--------
GOOGLE is a great resource to find answers to questions like "how do i..."

If you don't know exaclty what you want to do or what to search on, try Google Suggest:

http://www.google.com/webhp?complete=1&hl=en

--------
I have recently been semi-converted to ensuring all my code (well most of it) works in both javascript and non-javasc

 

[brad1978]

Cool, Thanks for the help guys!
B

 

[GhostWolf]

Thanks aarellano, that solved my problem too.