Operation must use an updateable query. HELP
Code:
dim conn
dom rs
set conn=server.createobject("ADODB.connection")
conn.open "db"
set rs = server.createobject("ADODB.recordset")
sqlq = insert into table1 (field1) values (1)
set rs conn.execute(sqlq)
Hi,
after the above code I get an erro
Operation must use an updateable query.
anyone know why?
without the recordset im still getting same error
[code]
dim conn
set conn=server.createobject("ADODB.connection")
conn.open "db"
sqlq = insert into table1 (field1) values (1)
conn.execute(sqlq)
[\code]
still says i need an updateaBLE QUERY