Modified Date

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

 

[Marshall Barton]

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!!

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.

 

[John Spencer]

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.

 

[Bill]

John, that it - I compact repair all the time!!
Thanks.
Bill.