How to compact/repair an mdb?

[NoobParadox]

Is this something I can do from within Access or do I need external tools? My database is needlessly large and I want to make it a bit more manageable if possible.

 

[Zigzag]

Is the database split?

 

[NoobParadox]

I don't know what you mean by that, sorry!

I just have one .mdb file with a few tables, reports, forms, and modules within.

 

[Zigzag]

Access 2003 to compact

Tools > Options > General tab
There is an option for 'Compact on close' Select this and click 'Apply'

This option can be set with VBA if you don't want it to compact every time the db closes.

Compact and repair
Tools > Database Utilities > Compact and repair database.

 

[NoobParadox]

I use 2007 and am looking under Database tools... so far no compression options


EDIT: Ah, I had to Customize and add it in manually. Frustrating!

Thanks

 

[Zigzag]

Sorry, I don't do 2007 but I am sure it is there somewhere.

 

[pbaldy]

FYI, you shouldn't have to customize to get the option. It should be accessible through the Office Button and Manage.

 

[NoobParadox]

FYI, you shouldn't have to customize to get the option. It should be accessible through the Office Button and Manage.

Right you are -- thanks for pointing this out!

 

[pbaldy]

No problem, and welcome to the site by the way!