I'm pretty new to all this Access stuff but recently I worked on an Access DB that was growing very quickly. I found that compact and repair was doing just what I need to keep this DB in a reasonable size.

Can I automate the compact/repair fonction into a script that will run during low frequentation hours?

I Think that all users must be disconnected before doing so, can I also automate this in a scheduled script.