Compact on Exit

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
 
B

Bruce M. Thompson

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

:)
 
B

BobV

Bruce:

Thank you for the answer to my question. This is what I was looking for.

BobV
 
Top