Compact an External Database

[Guest]

I have a database that does processing in several BackEnd databases. Is there
some code that I can run in the Processing FrontEnd that will Compact the
BackEnd databases?

 

[Douglas J. Steele]

You can use the CompactDatabase method of the DAO DatabaseEngine.

What I always do is rename the database to something meaningful (like
putting a date in its name, and/or changing the extension to .bak), then
compact that renamed database to the "proper" name. That way, you have a
backup as wrong.

 

[Bob Hughes]

You can use the CompactDatabase method of the DAO DatabaseEngine.

What I always do is rename the database to something meaningful (like
putting a date in its name, and/or changing the extension to .bak), then
compact that renamed database to the "proper" name. That way, you have a
backup as wrong.

I have a little function I created with the help of these news groups
http://www.treeful.com/fCompactBE.txt
It runs automatically in one of my DB's after 6 PM. I believe it is still
functioning properly. But I have not tested it for some time.

Bob

 

[Guest]

I used this method and it works great. Thanks!

You can use the CompactDatabase method of the DAO DatabaseEngine.

What I always do is rename the database to something meaningful (like
putting a date in its name, and/or changing the extension to .bak), then
compact that renamed database to the "proper" name. That way, you have a
backup as wrong.