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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top