Retrieving file dates

[Rackham]

Hello,

Is it possible from within my database to retrieve and display in a form the
'Created', 'Modified' and 'Accessed' dates of a linked table.

Thanks for any help

 

[Douglas J. Steele]

You can do it using API calls. Randy Birch has a complete example at
http://vbnet.mvps.org/code/fileapi/filedatetime.htm

Obligatory warning: Randy's site is aimed at VB programmers, not Access
programmers. Because there are significant differences between the Forms
model between the two, some of his examples don't translate to Access. I
took a quick look at this example, though, and I don't believe there should
be any problems porting it this time.