Last time database was modified.

[Guest]

I would like to capture the last time the database was modified and have it
displayed on my main form when opening the Access application. Currently this
information can be found under properties for the database itself, but I want
to capture that information.

 

[Bill Mosca, MS Access MVP]

You can get file infomation using the FileSystemObject.
Dim fs As Object
Dim f As Object
Dim strModDate As String

Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile(CurrentProject.FullName)
strModDate = f.DateLastModified
Debug.Print strModDate
Set f = Nothing
Set fs = Nothing