Compacting Split Database (1 Viewer)

[PeterOC]

Hello,

I've got a database which user's access over citrix. It's a split database with some large tables (about 600,000 rows in the largest). I have the back end part of this database set to compact on close but it's taking a good 10 minutes to do so. Is there a way to speed this up and should I be worried that it's taking so long?

thanks,

Pete

 

[apr pillai]

The compacting action does several things:

1. Closes the active database.
2. creates new empty database
3. copies all the objects (except temporary workobjects) from the parent database into the new database.
4. deletes the parent database.
5. renames the new database with the parent database name.

Large databases takes some time to complete these tasks.

Learn how to compact several databases one by one: http://www.msaccesstips.com/2008/06/repairing-compacting-database-with-vba/