Re: Open a ADODB.RecordSet from a Procedure

Tech-Archive recommends: Speed Up your PC by fixing your registry



execute directly sql commands

dim cn as adodb.connection
set cn = new adodb.conneciton
cn.connectionstring = "provider=...."
cn.open

'now execute command
cn.execute("")

so you
cn.execute("update test set order = 'X'")


.