Terminalserver and ACCESS

  • Thread starter Reiner Harmgardt
  • Start date
R

Reiner Harmgardt

Hi NG

I was told, that i had to perfectly close recordsets
and database after use, because if not,
it would use RAM-space on the Terminalserver
until it's shut down, which will normally not be done
every day.

Does anybody know, if it is possible to free this occupied
space on the Terminalserver with an other action than
shutting down?

Thanks and a nice week for everybody

Reiner
 
A

Arvin Meyer

Just specifically close any recordsets you open, and set the variable to
Nothing. This is just clean coding practice anyway.

Dim rst As DAO.Recordset
Set rst As CurrentDb.OpenRecordset("Select * From Whatever")

Exit_Here:
rst.Close
Set rst = Nothing
Exit Sub

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top