Is there a record timestamp somewhere in Jet

Is there a record timestamp somewhere in Jet - and how read it?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hugh webster - 23 Jan 2006 17:52 GMT

I have a client whose Access 97 tables have been corrupted at sometime,
but the application still functions.
They want to know whether the errors all occured on one day in the past,
or whether they occur from time to time (and so may happen again!)

Unfortunately the tables do not include some kind of a Last Updated field.
(They do include an Auto-number field, but as the database has been
replicated these are random numbers, and so useless for trying to see if
the errors all occured over some period in the past. PS: replication does
work, but avoid it if possible)

I'll bet that Jet automatically adds a TimeStamp (DateCreated or
LastUpdated) field somewhere in each record. Does anybody know how to get
it?

Many thanks, Gentlemen.

Reply to this Message

Steve - 23 Jan 2006 18:35 GMT

I don't know if what you seek exists, but here's a suggestion for you
while we wait for someone more experienced to respond. You can see
system tables by opening your database and going to Tools > Options and
choosing checking the option that allows you to view system tables.
These tables have a 'sys' prefix and contain information about your
database and the objects within it. If a timestamp for the records
exists, that's probably where you'd find it.

Reply to this Message