Access keeps restarting

[Keith Robards]

I have an application in Access 2000 that normally works fine, but when I go
through a certain routine, thereafter when I close Access, it restarts with
no database open. The only way to recover after this is to log off the user
or restart the computer (Win2000 or Win98).

Any ideas?

 

[Brian]

I have an application in Access 2000 that normally works fine, but when I go
through a certain routine, thereafter when I close Access, it restarts with
no database open. The only way to recover after this is to log off the user
or restart the computer (Win2000 or Win98).

Any ideas?

What is the "certain routine"? Are you sure that Access is actually
resarting? Could it be that the Access MDI window simply doesn't close?
This is a known problem in Access 97, and could be caused by one of two
things:

- failing to de-reference objects (i.e. not setting them to Nothing)
- implicitly referring to the value of a Check Box i.e. "If chkSomeBox
Then..." as opposed to "If chkSomeBox = True Then..."

When this happened in A97, the window could be closed using the Task
Manager.