DB Grows, possible to auto compact DB?

[ChaseCox]

Hello All,

I was wondering if anyone had ever experienced this.

When ever I use my DB, it continues to get larger. Is there away to automatically compact the database upon closing or opening? Any help would be greatly apprecited.

If you need some more information, please let me know.

[NeoPa]

Good job.
Did the /nostartup have the desired affect?

[ChaseCox]

Good job.
Did the /nostartup have the desired affect?

I did not use that, so I do not know. This is what I used.

@echo off
cls
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "S:\XTEAM\Reliability\Falcon_Analysis.mdb"/Compact
 

[NeoPa]

Presumably this gave you the same problem as before then?
You're obviously happy enough so I can be too :)

[ChaseCox]

Presumably this gave you the same problem as before then?
You're obviously happy enough so I can be too :)

No, it does not prompt me to say ok once it is finished running.