ADO Update Method

I'm writing a small script. Basically all it does is assign some variables from a query string and adds the values to a database. When call rs.addnew (rs being my recordset object) I assign my values and everything runs fine until I attempt to update the database. When I call the update method it gives me an error saying that the database doesn't support updating. I know that the database needs to support updating but how do I get it too? The database is a standard MS Access one.

Thanks,

Show us the code that is causing the error, and copy the exact error message for us to see.

This is the first thing you should do after searching the web and FAQ section for your problem, which is one of the most common found.

Cheers,
Andrew

You're not specifying a locktype here:

rs.Open "list", conn

Read here for info on how to do this:
http://www.adopenstatic.com/faq/jetcursortypes.asp
http://www.adopenstatic.com/faq/800a0bb9.asp#RecordsetOpenSyntax

Additonally, if you're not going to iterate through your recordset, then why create a recordset at all?

You could simply execute an INSERT statement through your existing connection. Something like:

strSQL = "INSERT INTO [YourTable] ('NameFirst','Email','Zip') VALUES (' & fn & "','" & zip & "','" & email & "')"

conn.execute(strSQL)

Cheers,
Andrew