Updating and Deleting from access 2k w/ ASP

[desktophero]

I am having trouble switching code from a SQL server to Access 2000 - I hate to say it but I have to!

Anyway, I can run SELECT statements all day long, but as soon as I try to do DELETE or UPDATE or INSERT - the errors start to fly. I have tried DSNs, etc. but I can't get anything (except the SELECTs) to work.

I am using

set conn=server.createobject("ADODB.Connection&quot
conn.open "DRIVER=Microsoft Access Driver (*.mdb);UID=Admin;DBQ=database;DefaultDir=default"
set rs=server.createobject("ADODB.Recordset&quot
rs.open "tablename", conn

rs("Fieldname&quot.AddNew
rs.Update
rs("Fieldname&quot.Value=1
rs.update

rs.close
conn.close

Any suggestions?
Thank you in advance!

Jason