Compact a Split DB

[Mmccl]

Hi All,

I have split my DB into front and backend. I have compact and repair set to run at close.

Seems that the back end is not compacting. Is there a way to compact a backend DB without opeing it? ie. can I make a control button or a menu item that will compact both FE and BE DB's?

Or is there VBA that will do this? What would it look like?

Stumped Again
Mike

 

[wizcow]

mmccl

There is a sample here

Compact BE

HTH
Tom

 

[IpeXeuS]

Thanks for the link dude...