Access won't release from memory.


Phil Bickler

I have installed Access 2000 on a new Fujitsu Tablet PC
running XP Tablet edition. While Access works fine, when
you exit the program, Windows is not releasing it from
memory. If I open and close Access 3 times, if I
CTRL+ALT+DEL and check System Processes, MSACCESS.EXE has
three instances running in memory. This does not happen
with any other Office program, just Access. Any ideas?

David Straker

Arvin Meyer suggested the following on Oct 22 in one of his replies:
There is either a boolean control (usually a check box) which is not being
referred to explicity:

Instead of: If Me.chkBox Then

Use: If Me.chkBox = True Then
Or: If Me.chkBox.Value Then

Or there is a recordset left open and not closed in the exit procedure. Make
sure you explicity close objects you create:

Dim db As Database
Dim rst As Recordset

Set db = CurrentDb
Set rst = db.OpenRecordset("blah, blah")

Set rst = Nothing
Set db = Nothing

Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:


I am having the same issue using a portege 3500 Tablet PC.
I am sure the solution with the check box is not the
problem. I am eager to find a solution if anyone has one

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