ASP - Need help updating my database

[HamSupLo]

I created a form where I can insert a new record into my Access database.

Here's my script:

<%
pname=Request.Form("pname")
ppicture=Request.Form("ppicture")
pinfo=Request.Form("pinfo")
pdesc=Request.Form("pdescription")



Set conn=Server.CreateObject("ADODB.Connection")
conn.open "DSN=db1"

set rs=Server.CreateObject("ADODB.recordset")
rs.open "state", conn, 1,2

rs.AddNew
rs("program_name")=pname
rs("program_info")=pinfo
rs("program_desc")=pdesc
rs("pictures")=ppicture
rs.Update


%>

and when i submit, i get this error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
/test3.asp, line 30

Any help is appreciated!

 

[notfred]

set the database writeable?

 

[edmicman]

you probably can't have the db open while your editing/adding things to it via asp either

 

[HamSupLo]

Originally posted by: Tyler
set the database writeable?

how do i do that? i enabled all thinkable permissions in Access already.

 

[zigCorsair]

Dood - ASP is a bit vague.

Make sure your NT permissions are set correctly - the IUSR_WEB or whoever it is needs modify access 🙂

 

[rh71]

<--- glad he learned ColdFusion instead. What a mess that is! 😉

 

[HamSupLo]

a quick bump.

- i'll check that IUSR_WEB thing