To do this programatically, check out JRO (Jet Runtime object) and the compactdatabase command:
strConnOriginal = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=D:\Program Files\MyApp\Orig.MDB;"
strConnNew = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=D:\Program Files\MyApp\New.MDB;"
Set jroEngine = New JRO.JetEngine
jroEngine.CompactDatabase strConnOriginal, strConnNew
>Hello,
>
>PLEASE HELP...........
>
>I'm writing a little system with Access, but the expansion of the file size is scaring me, so I wondering is there any command can compact/shrink the database, instead of doing it from Access menu bar?
>
>Thank you very much
>Aston