View Single Post
Old 09-16-2019, 11:44 AM   #17
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,271
Thanks: 15
Thanked 1,595 Times in 1,515 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Last updated object in a database

I don't want to edit the MSysObjects table, I just want to be able to determine when the last database object was changed. I use a query based on MSysObjects
Code:
SELECT MSysObjects.Name, MSysObjects.DateUpdate, MSysObjects.Type, MSysObjects.Name & " -- " & MSysObjects.DateUpdate AS UpdateData
FROM MSysObjects
WHERE MSysObjects.Type In(-32768, 5,-32764, -32766)
ORDER BY MSysObjects.DateUpdate DESC;
But I have found that I can change forms and save them and this query will not reliably show the change.

The query does not include modules or tables because these seem to get updated when I don't change them.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
The Following User Says Thank You to Pat Hartman For This Useful Post:
Tera (09-16-2019)