Hello, I am using an ACCESS DB for a coldfusion website.

I just compacted it and it went from 1.4 MB to 288 KB.

What causes a DB to bloat like this and is there a vay to compact and repair the db with a command?

Thanks