Automaticaly Compacting Database

[apoena]

Is there a way I can compact my db automaticaly every time I close it? I tried using the "DBEngine.CompactDatabase" cmd, but it requires that you close the db 1st. But once you close it, how can you run the rest the code telling it to compact itself?

Is this another catch 22 from MS?

Thanks in advance!!

 

[JoeMiller]

If you look up command line options in the help it will tell you how to compact the database upon startup with a command line.. Would this work for you?

Joe Miller
joe.miller@flotech.net