[thelist] asp update existing record

[Lightning]

I am trying to update an existing record. The sql statement is fine.

 dsn="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\inetpub\wwwroot\WhiteLightening\db\buzz.mdb;Persist Security
Info=False"
Source=c:\webspace\stpsecureservers\WhiteLightening\WhiteLightening.net\db\b
uzz.mdb;Persist Security Info=False"
set cnBuzzConnection = server.CreateObject("ADODB.Connection")
set rsActivity=Server.CreateObject("ADODB.RecordSet")
 rsActivity.Open sql,dsn,,3

 rsActivity.close
 set rsActivity=nothing


I get this err msg:


Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/WhiteLightening/www/Buzzell/ActivityUpdate.asp, line 315

I suspect problem is in rsActivity.Open sql,dsn,,3

I can't find out what the two number parameters on the end are SUPPOSED to
be, so I have been reduced to experimenting.

thanks, Laura