By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,501 Members | 2,817 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,501 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Jan 23 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Jan 23 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.