Find Modified Date of a Table

[Lillian]

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

 

[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.

 

[Douglas J. Steele]

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

 

[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.

 

[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.

 

[Lillian]

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.

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.

 

[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.

 

[Douglas J. Steele]

Putting it in the form's BeforeUpdate event might work better.