Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. heiland5

    Set Database Option 'COMPACT On Close' by code

    Thanks "TheAceMan1". I also found the same code in a different web search.
  2. heiland5

    Set Database Option 'COMPACT On Close' by code

    Found it: Application.SetOption ("Auto Compact"), 1
  3. heiland5

    Set Database Option 'COMPACT On Close' by code

    As related to Thread number "thread705-909476" on compacting an Access database within VBA, how can I change the "Compact on Close" option (Tools --> Options) on-the-fly within VBA code when an Access application program is opened? Thanks!

Part and Inventory Search

Back
Top