About the modified date/time of Access

  • Thread starter Thread starter Jing
  • Start date Start date
J

Jing

Hi there,

I have a question about the modified date/time of Access:

Everytime I open an Access file, then open table or form,
don't modify anything, then i close the file, the modified
date/time of this file gets changed to current. I am
wondering if it's normal, or whether I can avoid this
problem(the modified date/time of this file gets changed
to current)? Thanks!

Jing
 
Hi there,

I have a question about the modified date/time of Access:

Everytime I open an Access file, then open table or form,
don't modify anything, then i close the file, the modified
date/time of this file gets changed to current. I am
wondering if it's normal, or whether I can avoid this
problem(the modified date/time of this file gets changed
to current)? Thanks!
Click to expand...

This is normal, and I know of no way to modify this behavior. The
"modified date/time" property of the file is pretty much useless! If
you want to keep track of when data in your tables was modified you
must do so yourself, using a Date/Time field either in the table
itself or in a log table, and writing VBA code in the Form that you
use to edit the data to record the date.
 
Got it. Thanks John!
-----Original Message-----


This is normal, and I know of no way to modify this behavior. The
"modified date/time" property of the file is pretty much useless! If
you want to keep track of when data in your tables was modified you
must do so yourself, using a Date/Time field either in the table
itself or in a log table, and writing VBA code in the Form that you
use to edit the data to record the date.


.
Click to expand...
 
Back
Top