Track date of Updated records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jerry.ranch@pioneer.com - 17 Jan 2006 17:50 GMT

Say I have a form.

On this form I want to reports back the last date data in any table
was modified (say in a subform, or other object??)

This way the user can see when the last update of information
occurred.

I was thinking I could run a qry that looks at MSysObjects, pull the
rows specifically of the tables I want to check, and take the largest
value in DateUpdate field, and report it out on a subform.

Could I use the Timer feature of the form to run the query, say every
hour then?

Thanks
Jerry

Reply to this Message

Jamey - 18 Jan 2006 00:41 GMT

I've looked at something like that before, but MSysObjects changes
periodically. For example, in A2K DateUpdate doesn't change at all and
is merely set to DateCreated.

You could add a field to track the value for you and set it to track
UserName and Time via the Now function. I'd stay away from DateUpdate
just because MSysObjects isn't consistent from version to version.

Reply to this Message

Jerome Ranch - 19 Jan 2006 00:45 GMT

Everyone in the company uses the same Access version.
But to build it so that it might break when we upgrade is not the
proper way to build an app.
I will try your suggestion.
Jerry

>I've looked at something like that before, but MSysObjects changes
>periodically. For example, in A2K DateUpdate doesn't change at all and
[quoted text clipped - 3 lines]
>UserName and Time via the Now function. I'd stay away from DateUpdate
>just because MSysObjects isn't consistent from version to version.

Reply to this Message