Last Modified Date

[Mark T]

I am doing application developement and need a way to get the LastModified date for all objects in a database. I know using ADOX I can get the info on Tables, however I need this information on Forms,Macros,Queries,Reports and Modules, Anyone know the answer??

 

[Douglas J. Steele]

You should be able to query the (normally hidden) MSysObjects system catalog
table. It has a field named DateUpdate. However, I seem to recall reading
that there are problems with its accuracy in newer versions of Access (due,
doubtlessly, to the fact that Access saves everything, not just what was
changed, since Access 2000)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I am doing application developement and need a way to get the LastModified

date for all objects in a database. I know using ADOX I can get the info on
Tables, however I need this information on Forms,Macros,Queries,Reports and
Modules, Anyone know the answer??

 

[Mark T]

I did check that out, the information listed is the Last Updated date, I'm looking for last Modified Date