Compacted Date

[stephen81]

Can anyone tell me a way to retrieve the date a database was last compacted?

 

[Mile-O]

There is no Last Compacted property in the way there is a LastUpdated property.

You'd have to program a bit of code that compacts the database and stores the date and time in a table.

 

[stephen81]

Is that straightforward to do? I haven't done much with vba so could you point me in the right direction?

 

[Mile-O]

Maybe one of these links can help or guide you a little:

Former

Latter

 

[stephen81]

Thanks Mile-O-Phile

The latter one has helped me a bit and I have managed to partially solve my problem without any coding. I have used the a macro to record the date and then the send keys function to choose compact from the menus i.e. "%tdc" which means I can automatically compact the database I'm working in. The only problem I've got though is that if the user clicks on Compact database on the menu themselves, it won't register the date in my table. I can't take that off the menu so they can't click on it otherwise my send keys function won't work. Is there any way to maybe hide menu items but still have them available to my send keys function?


Stephen