469,611 Members | 1,933 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

compact on close using docmd.menuitem

Hello everyone.

happy new year.

I am trying to code an exit button for my application so that it
automatically compacts the database when the user exits the app. Is this
necessary or does the "Compact on close" option work even when the
database window is not displayed? Is it best to "roll my own" or not? My
second question is what are the constants to use to get to the compact
and repair database option on the tools menu?

Thank you

Colin Ward

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
1 2105
The Compact On Close will work whether the database window is open or not.
When you close the database, it will compact. What will be compacted will be
the front-end if you have a split database.

--
Wayne Morgan
Microsoft Access MVP
"ColinWard" <je*********@hotmail.com> wrote in message
news:3f***********************@news.frii.net...
Hello everyone.

happy new year.

I am trying to code an exit button for my application so that it
automatically compacts the database when the user exits the app. Is this
necessary or does the "Compact on close" option work even when the
database window is not displayed? Is it best to "roll my own" or not? My
second question is what are the constants to use to get to the compact
and repair database option on the tools menu?

Thank you

Colin Ward

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by James Franklin | last post: by
2 posts views Thread by lestersal | last post: by
1 post views Thread by smitty mittlebaum | last post: by
1 post views Thread by Mark | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.