I believe, if you move up to Access 2k or so you get a 2GB limit, but my experience is that above about 1GB you get lots of corruption issues.

Anyhow, you can compact an MS-Access DB via the Win32 modules and I'm sure somebody here can give you the syntax for that particular command. I just want to caution you against it. My experience is that the compact/repair experience in Access causes tons of problems and generally should be done under full supervision. I can't count the number of times doing one/both has corrupted my DB or reverted back to older table structures and relationships. So, I'm not a big fan of automating it, and I would urge you to do some sort of testing afterwards, and to take a file-level backup (just copy the .mdb file) before.

Hope this helps!
-Tats