Access Last Updated Date

[team4344]

I am using Access 97, i have created a Switchboard...

Hi i would like to insert onto the Switchboard the date and or time at which the database was last saved. Is this possible ?

 

[wemeier]

What exactly do you mean by saved? The last time any object within the database was modified, the last time the database was opened, or the last time that data was modified within any of the database's tables?

Generally, there is no way to tell when the last time data was updated within a database's tables. There is a way to identify when the database was last OPENED. There is also a way to identify when the last object (query, form, report, macro, etc.) was modified.


Cruising the Information Superhighway
[sub] (your mileage may vary)[/sub]

 

[SkipVought]

Hi,

Generally, what is done for date/time critical tables is to have a column datestamp. Each time a row is Inserted/Updated (often no row delete occurs but the row is marked for deletion after various audits have occurred) the datestamp refleces the date/time of the transaction.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com