Database Not Compacting Completely on Computer

[Ed Ardzinski]

Windows network, Access 2003 database - not an MDB.

Whne I compact the development version of the database it doesn't compact
nearly as much as it does on my collegues computer. Has anyone ever
encountered this or have an idea why the compact/repair feature would not
work the same between different boxes?

Thanks!

 

[Allen Browne]

There's probably a difference in service packs between the 2 computers.

To get it back to minimal size, try this sequence:
1. Delete anything you don't need (data, indexes, graphics, queries, ...)
2. Compact
3. Decompile
4. Compact
5. Compact again
6. Create a new database
7. Import everything.
8. Compile

The new database at step 8 will be smaller than the compacted one at step 2.