I have this code,

Dim rec as ADODB.Recordset
rec = New ADODB.Recordset

Now, if i do this,
rec.Open "tableName", conn, adOpenStatic, adLockBatchOptimistic
it gives me error, saying SQL statement expected

however, if i do this

rec.Open "SELECT * FROM tableName", conn,......
it has no error but i cant modify anything in the table

i need to do rec.Update.Fields("fieldname").Value = somevalue but i need the rec.Open to work

help?