How to reduce Access file size?

[aywho]

Hi,

I have a db with some dummy data. After I delete them, the file size still won't go down. Is there any way that I can remove all the dummy data, and have the smallest file size possible?

Thanks a lot.

 

[maxmangion]

you need to compact and repair the database from the Tools menu!

 

[Ron_dK]

aywho,
do a search on "database size growing" and you will find lots of info on this subject.

 

[aqif]

use decompile method

One of the advanced methods of reducing sizoe of Access DB is to open the file in decompile mode and than compact and repair. To do that

in Start-->Run type

"C:\Program Files\Microsoft Office\Office\MsAccess.exe" /decompile

then browse for any file you want to compact

Open any module and then click on Debug-->Compile all

then goto Tools-->Database Utilities-->Compact and Repair database

Close module and then compact database again

Cheers!
Aqif