Find Modified Date of a Table

L

Lillian

How can I find a tables modified date.
I am using filedatetime for files.
How do you use it for tables?
 
T

Tom van Stiphout

On Fri, 02 Nov 2007 21:11:22 -0500, Lillian <[email protected]>
wrote:

Assuming your tablename is Employees, you could write:
Debug.Print
DBEngine(0)(0).TableDefs("Employees").Properties("LastUpdated")

-Tom.
 
D

Douglas J. Steele

Unfortunately, I don't believe that works in versions of Access since Access
97.
 
T

Tom van Stiphout

On Sat, 3 Nov 2007 07:15:26 -0400, "Douglas J. Steele"

Not so. It works in Access 2000 and 2007.
-Tom.
 
D

Douglas J. Steele

My apologies. I had thought that the value was the same for all tables in
the database (due to the monolithic save in the newer versions of Access),
but a test I just ran indicates that that isn't the case.

However, it should be pointed out that it represents the last time a change
was made to the table design, not the last time a change was made to the
data in the table.
 
L

Lillian

Douglas said:
My apologies. I had thought that the value was the same for all tables in
the database (due to the monolithic save in the newer versions of Access),
but a test I just ran indicates that that isn't the case.

However, it should be pointed out that it represents the last time a
change was made to the table design, not the last time a change was made
to the data in the table.
Click to expand...


This works for me. Is there a way when the data is changed to pull the
modified date and time?

I don't need it now but later I might.
 
T

Tom van Stiphout

There is no built-in way to get that.
If you REALLY need it, I would suggest using SQL Server instead: it
supports triggers which can fire when you update or add data.
In Access you would have to rely on the Form_AfterUpdate event.

-Tom.
 
Top