Question Database Properties: dates

[djnoser]

The Database Properties "Statistics" tab on my databases show a correct "Created:" date but the "Modified:" and "Accessed:" dates are 2+ years prior to the correct date. All three dates on the "General" tab are incorrect.

Because the "Modified:" date is displayed in Windows Explorer, it takes some mental math to determine when a database was last modified.

How can I fix this???

 

[Trevor G]

The Database Properties "Statistics" tab on my databases show a correct "Created:" date but the "Modified:" and "Accessed:" dates are 2+ years prior to the correct date. All three dates on the "General" tab are incorrect.

Because the "Modified:" date is displayed in Windows Explorer, it takes some mental math to determine when a database was last modified.

How can I fix this???

Welcome to the Forum,

You would need to consider looking at some VBA to update prior to closing the database or as it opens !

In the vba screen you can add a module via the Insert Menu and then create a Function to do this.

To get a list of properties or create new ones you need the VBA code.

Look around this type of code

Sub prop()
Application.CurrentDb.Properties
End Sub

Take look at this link to get you going.

http://www.everythingaccess.com/tutorials.asp?ID=Custom-Database-Properties