How's the VBA to compress the database

M

Martin Lee

First of all, thanks for your help. I now know the following VBA sentence
can set the auto compact:
Application.SetOption "Auto Compact", True

Yet, I am now have another quetion:
I want to carry out a "compress operation", how's the VBA sentence should
be?

Thanks!

Martin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compact Database 3
Excel VBA to delete records in Access table and reset the Autonumber 1
Need Help with a VBA subroutine 0
How to Change criteria on a saved query using VBA 0
VBA word change keys 0
How to compress a database automatically just bevore exiting ? 0
reduce Access 2007 database size 6
How to make it DESC in such VBA ? 2

Top