ado woes

[Bam_BamIR]

is there any reason why an ado recordset obj would close if you did not code it to close?

[parksie]

Maybe if the provider timed out.

[Bam_BamIR]

are you referring to "provider" as a network connection? if so using local machine no net conn

[parksie]

No, provider as in the database access provider (such as SQL Server or Access). If you don't keep the connection alive it may timeout and close it.

[Bam_BamIR]

i think i know where im going wrong,. im using a single object and returning a single record(set) and when i do a new search the old recordset has been replaced with the new one something like that. just gonna take time to convert from dao to ado things are handled a little odder than dao
thnx