Hi All,
MS Access 2003 - using a split database.
I am using a switchboard. I have set in Options to "Compact on Close".
What code do I put behind the Exit button on the switchboard so the
database Compacts the FE on Close and closed the MS Access Window?
If I just use "Application.Quit acQuitSaveAll" it does not compact the
database.
If I use CloseCurrentDatabase it compacts the database but keep the MS
Access window open.
It I use both CloseCurrentDatabase and Application.Quit the MS Access
database window still remains open.
Any ideas how I can ensure that the database FE both compacts and
closes the MS Access application?
Thanks,
Barry