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!)
Mark T said:
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??