Dim Result As Date Result = FileDateTime("C:\examples.mdb")
Now the result variable would contain the create or last modified date for the examples.mdb file. The format of the date and time displayed is based on the locale settings of your system.
SQL query
You can also use the FileDateTime function in a query.
SELECT EmployeeStatisticsTable.EmployeeIDNo, FileDateTime('C:\Program Files\Outlook Express\msoe.txt') AS Expr1 FROM EmployeeStatisticsTable
Note:
This function cannot be used in expressions when Access is operating in safe mode.