469,957 Members | 2,330 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,957 developers. It's quick & easy.

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
Jan 7 '08 #1
3 1912
"Barry Edmund Wright" <bw**************@sympatico.cawrote in message
news:ed**********************************@p69g2000 hsa.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

Jan 7 '08 #2
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" <h...@there.comwrote:
"Barry Edmund Wright" <bwright_msacc...@sympatico.cawrote in messagenews:ed**********************************@p 69g2000hsa.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
Jan 26 '08 #3
Barry Edmund Wright <bw**************@sympatico.cawrote:
>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/
Jan 28 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Neil Greenough | last post: by
8 posts views Thread by Ray Greene | last post: by
reply views Thread by jorgedec | last post: by
reply views Thread by rainxy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.