Access Table Creation Date

[kashew]

How do I get the date that a table in a database was created and/or modified?

 

[AccessSQLUser]

You could right click on the table and view the properties. Or do you want it in code?

 

[Aivars]

dim TableDateCreated, TableLastUpdated

TableDateCreated=CurrentDb.TableDefs("TableName&quot.Properties("DateCreated&quot.Value
TableLastUpdated=CurrentDb.TableDefs("TableName&quot.Properties("LastUpdated&quot.Value

Aivars

 

[MichaelRed]

SELECT MSysObjects.DateCreate, MSysObjects.DateUpdate, MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "MSys*&quot AND ((MSysObjects.Type)=1));

MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over