disable the compact database

[ahau]

Hi,

I was wondering if anyone might be able to help me. I have a database that would compact just before it closes the application. However, i have decided not to use it anymore so i commented it all out the code. However, it still does compacting whenever it closes the access application.

Here is my code
Private Sub CB_Exitbase_Click()

DoCmd.Quit acQuitPrompt

End Sub

Private Sub Form_Unload(Cancel As Integer)
If MsgBox("Are you sure you wish to close this screen?", vbYesNo + vbQuestion) = vbNo Then
Cancel = True
'Else
'Call CompactOnClose
End If
End Sub

I've been looking all over the place on the menu options but to no avail.

Any ideas?

Thank you in advance

 

[PHV]

menu Tools -> Options ... -> tab General

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886