Access won't release from memory.

  • Thread starter Thread starter Phil Bickler
  • Start date Start date
P

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?
 
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
________
 
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
 
Back
Top