Modified 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.
 
M

Marshall Barton

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

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