RE: Best practices in ADO

dim ConXion as new Adodb.connection
dim rs as new adodb.recordset

if conxion.state = 0 then
ConXion.open " database location string"
end if

rs.open "select something from sometable", method here, lock here

do
what you want with the records
loop

if u are done

rs.close
set rs = nothing

if u don't need the connection


if conxion.state = 1 then
conxion.close
set conxion = nothing
end if

"Sergi" wrote:

> Can someboy post some best practices with ADO?? Do you know some website?
>
>
>
.