is there any reason why an ado recordset obj would close if you did not code it to close?
Printable View
is there any reason why an ado recordset obj would close if you did not code it to close?
Maybe if the provider timed out.
are you referring to "provider" as a network connection? if so using local machine no net conn
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.
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