Access Not Closing - Open Recordsets

[PaulSc]

Hi,
I wonder if anybody can help me please.

We have a database that on certain occassions, and only on a few pc's, when it is closed via the DOCMD.QUIT routine, closes the database but leaves Access 97 open.

From previous searchs we found that its most likley caused by Open Recordsets/querydefs etc and have made the effort to ensure that once opened they are closed. In addition we have installed SR2 on all the PC's as this is also required.

This cured 95% of the problems, however on the odd pc it still happens...

What I would like to be able to do is to have a routine which can display any Open recordsets? Does one exist or has anybody done anything similar?

Thanks in advance.

Paul.

 

[Tzokas]

PaulSc,
Try to use the Quit Method (Application Object).
The following is from the MS Access Help Example, or see the Full Help Topic for this method.

The following example shows the Click event procedure for a command button named AppExit. After clicking the AppExit button, a dialog box prompts the user to save changes, and the procedure quits Microsoft Access.

Private Sub AppExit_Click()
        Application.Quit acPrompt
End Sub

Good Luck