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")

rst.Close
Set rst = Nothing
Set db = Nothing

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

 

[Phil]

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