Compact on Exit

[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

 

[Bruce M. Thompson]

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

exit?

Application.SetOption "Auto Compact", True

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

Application.SetOption "Auto Compact", False

 

[BobV]

Bruce:

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

BobV