access 2000 hangs under XP tablet

[Guest]

I just bought my wife a new Thinkpad X41 - 1.5 GB RAM, XP Tablet edition.
She runs several Access 2000 databases for her business.
If she opens one of the 'mdb' files it works fine, but after closing the
file and reopening it nothing shows on the display, but the 'ldb' file is
created.
After closing the database the first time an instant of msaccess is left
running -seen as a process, but not a task.
If she opens a 'mde' file everything seems fine except a new msaccess
process is created and left running every time.
If she opens msaccess first and then opens the database files from within
everything seems to be just fine.


I have tried to reinstall Office 2000, but it did not help and nothing came
out of a search of the knowledge database.
What's going on???

 

[Arvin Meyer [MVP]]

This is caused by either of 2 bugs:

1. A recordset was not explicitly closed. Ocasionally, recordset variables
do not go out of scope when the procedure is over, so it is good programming
practice to clean up when you're done with them:

rst.Close
Set rst = Nothing
Set db = Nothing

If you open it, close it and set it to nothing. Do not close the current
database.

2. There is a Boolean control that is not explicitly referred to. Instead
of:

If Me.chkBox Then

use:

If Me.chkBox = True Then
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access