Simply put, I am have a function that is suppose to return a
disconnected recordset, but I have discovered that the recordset is not
disconnected, it is still holding a connection to the database untill
the recordset is set to nothing.
Here is my Function
Public Function GetPerson() As adodb.Recordset
Dim rs as adodb.recordset
'uses string to fill in the sql statement
sSql = ""
sSql = "SELECT blah blah......." 'long select statement but does
return what I need.
Set rs = New adodb.Recordset
OpenConnClient 'a sub that opens the connection to the database. and
the Conn.CursorLocation = adUseClient
.ActiveConnection = Conn
.CursorLocation = adUseClient
.CursorType = adOpenStatic
.LockType = adLockBatchOptimistic
Set rs.ActiveConnection = Nothing
Set Conn = Nothing
Set GetPerson = rs
Set rs = Nothing
In my form I set rsPerson = DA.GetPerson , so why is rsPerson still
connected to the database?
Never play leapfrog with a unicorn.
Sent via Deja.com http://www.deja.com/
Before you buy.