Modified Date

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Just noticed that all my queries have modified dates far more recent than
any change by me. Any idea what could be doing this because I often need to
order by that value!!

Regards.
Bill.
 
Bill said:
Just noticed that all my queries have modified dates far more recent than
any change by me. Any idea what could be doing this because I often need to
order by that value!!
Click to expand...


How are you setting the modified date?

Most likely, you are using the form's BeforeUpdate event.
If so, then I'll guess that you are using VBA code to set a
bound control's value somewhere. The form's Current event
is a suspicious candidate.
 
Have you compacted the database at any time?

If so, you will find that the last modified date gets set to the date
time of the compact, as does the Created date.

Been that way since Access 2000.
 
Back
Top