Compact on Exit

  • Thread starter Thread starter BobV
  • Start date Start date
B

BobV

Group:

I want to allow the user to determine whether they want to have the database
compacted upon exiting the program.

What is the VBA statement that I would use to compact the database upon
exit?

Also, what is the VBA statement so that the database will not be compacted
upon exit?

Thanks,
BobV
 
What is the VBA statement that I would use to compact the database upon
exit?
Click to expand...

Application.SetOption "Auto Compact", True
Also, what is the VBA statement so that the database will not be compacted
upon exit?
Click to expand...

Application.SetOption "Auto Compact", False

:-)
 
Back
Top