Compacting FE and Quiting Application from Switchboard Problem

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

Re: Compacting FE and Quiting Application from Switchboard Problem

"Barry Edmund Wright" wrote in message
news:eda5d63c-0d8c-4f65-b7d9-4fa73ab2327a@p69g2000hsa.google groups.com...
> 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?

Don't compact in the production environment. Compact your development front
end before you deploy it and use a batch file or Tony Toews' FE updater to
deliver a pristine copy to your users every time they start it.

HTH - Keith.
www.keithwilby.com

Re: Compacting FE and Quiting Application from Switchboard Problem

Thanks, Keith. Using Tony Toews' FE updater was a good tip. It works
very well, I would certainly recommend it.


On Jan 7, 9:08 am, "Keith Wilby" wrote:
> "Barry Edmund Wright" wrote in messagenews:eda5d63c-0d8c-4f65-b7d9-4fa73ab2327a@p69g2000hsa .googlegroups.com...
>
>
>
> > 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?
>
> Don't compact in the production environment. Compact your development front
> end before you deploy it and use a batch file or Tony Toews' FE updater to
> deliver a pristine copy to your users every time they start it.
>
> HTH - Keith.www.keithwilby.com

Re: Compacting FE and Quiting Application from Switchboard Problem

Barry Edmund Wright wrote:

>Thanks, Keith. Using Tony Toews' FE updater was a good tip. It works
>very well, I would certainly recommend it.

Thanks for your kind words.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/