Time when database was compacted

[Tom Vinson]

Is there a way to determine when an Access database was last
compacted, or if it has not been modified since the last compaction?
I need to run a utility program every night to compact databases, but
would like to do so only if it's really needed.

Thanks
Tom

[Tom van Stiphout]

Re: Time when database was compacted

On 7 Sep 2004 08:19:38 -0700, tom_vinson@mpsi sys.com (Tom Vinson)
wrote:

Check the modified date stamp on the MDB file.
-Tom.

[color=blue]
>Is there a way to determine when an Access database was last
>compacted, or if it has not been modified since the last compaction?
>I need to run a utility program every night to compact databases, but
>would like to do so only if it's really needed.
>
>Thanks
>Tom[/color]