Trouble closing access 97.

[merlin2049er]

Hi, I know it's an old version of Access, but it doesn't seem to quit
properly when exiting our database application (an accounting package).

We have to go to the task manager and kill Access 97. (Trying to shut it
down doesn't work)

Any clues?
TIA,
JG

 

[Douglas J. Steele]

See whether what's in http://www.mvps.org/access/bugs/bugs0005.htm at "The
Access Web" is relevant.

 

[Allen Browne]

There were a couple of problems in Access 97 that caused this behavior.

From memory, MS fixed them in the service packs, so your first stop might be
to look under Help About and see if you need to apply some service packs.
They are actually hard to find, but you can get Office 97 SR-2b from:
http://www.microsoft.com/downloads/...42-602e-42b0-89d2-6be39f1167c1&DisplayLang=en
and the JET 3.5 serrice pack from:
http://support.microsoft.com/kb/172733

If that doesn't solve the problem, the 2 causes were:
a) recordsets that you opened, but failed to close and set to Nothing

b) boolean controls (check box, toggle button, option button) that you
referred to like this:
If Me.MyCheckbox Then
which you can change to either of these (or other similar structure):
If (Me.MyCheckbox.Value) Then
If Me.MyCheckbox = True Then

In a large database, those things are not simple to track down.