Connecting Tech Pros Worldwide Help | Site Map

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

  #1  
Old January 23rd, 2006, 06:05 PM
hugh webster
Guest
 
Posts: 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.
  #2  
Old January 23rd, 2006, 06:49 PM
Steve
Guest
 
Posts: n/a

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


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.

Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Losing Data Neil Ginsberg answers 32 November 13th, 2005 07:30 AM
.MDB lockes records in tables linked via ODBC to SQL SERVER 2k orentini@hotmail.com answers 2 November 13th, 2005 04:26 AM
Who could solve this bug (in my balanced line) Koen answers 1 November 12th, 2005 10:23 PM
Linking an Mdb to SQL Server diskoduro answers 14 November 12th, 2005 07:12 PM
SQL Losing Data Neil Ginsberg answers 32 July 23rd, 2005 08:48 AM