From within Access97 (in a VBA module) I need to read the date/time last
modified of another .MDB file.

I can't find a function to do this... even over at Devs site <g>!...

I will pass the file path and name and I need to get back the date/time last
modified of the file.

Thank you in advance for any assistance you may provide.

I'm stumped!

*************************************
Please reply via EMail and the newsgroup

Paris - FRANCE            WWW: http://www.*-*-*.com/

Use the FileDateTime function

This example uses the FileDateTime function to determine the date and time
a file was created or last modified. The format of the date and time
displayed is based on the locale settings of your system.

Dim MyStamp
' Assume TESTFILE was last modified on February 12, 1993 at 4:35:47 PM.
' Assume English/U.S. locale settings.

MyStamp = FileDateTime("TESTFILE")    ' Returns "2/12/93 4:35:47 PM".

Hope This Helps
SMDavis

Weyerhaeuser a crit dans le message

Thank you.  I don't know why I couldn't find that in the help system...

I will give it a try tomorrow.

Thank you especially for the helpful detailed example.

-----
Please reply via EMail *AND* Newsgroup if possible.

Paris, FRANCE                      Web: http://www.erb.com