inserting into access database using ASP objects 1

[tusanesen]

i m trying to do a simple asp site based on Access. I can read from DB but, when i insert to DB, altough I am not receiving any error message, i can see nothing inserted in database.. what i did is

set db = Server.CreateObject("ADODB.Connection")
db.open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & database

set rs = Server.CreateObject("ADODB.RecordSet")
rs.open SELECT * FROM TABLE, db, 1, 3

rs.addnew()
rs.fields("FIELD") = field 'field is an assinged variable
rs.update()

(close and free rs and connection)


i guess i need to do some IIS settings or anyting but changing code?

thanks in advance

 

[GaryC123]

Make sure you have given the IUSR account write permissions on the db folder and remove any on error code to make sure you get an error msg if any and your rs code
rs.open SELECT * FROM TABLE, db, 2,2

http://www.eatdrinkandsleep.com

 

[tusanesen]

thanks garcy .. it was really usefull