By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,497 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Compacting FE and Quiting Application from Switchboard Problem

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
"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

P: n/a
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

P: n/a
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.