sql="update table1 set field1='good'" set cmd=server.createobject("adodb.command") with cmd .activeconnection=dsn .commandtype=adcmdstoredPRoc .commandtext=sql .execute lngrecs,,adexecutenorecords end with set cmd.activeconnection.nothing set cmd=nothing
