File Attributes - need to get automatically

[Voyager]

Hi
is there an api call that i can use to retrieve the file attributes of my access database file so can see when the last compact database was done. I need to do this insode my vb code

thanx
:)
Voyager

[czimmerman]

You can use API calls to obtain detailed information about a file. See http://www.freevbcode.com/ShowCode.Asp?ID=164 for a class that does this for you.

This will work for you if you can assume that the date the file was last modified is also the date it was last compacted. I know of no specific way to just check for the date the file was last compacted.