About the modified date/time of Access

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
 
J

John Vinson

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!

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.
 
J

Jing

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.


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top