A little over a year ago I wrote an article regarding retrieving a database object’s created and modified date/times:
Microsoft Access - Get Object Created Or Modified Date/Time
Getting the Creation Date/Time So have you ever tried to retrieve the Created Date/Time. Pretty easy right as there are a couple ways to attack this! You can simply query the MSysObjects table: Or perhaps use DAO Containers and Documents: Getting the Last Modified Date/Time But what about the Modified Date/Time? So you would think that we could simply modify the above query of the MSysObjects table to: Or the DAO Containers and Documents to: But those are not reliable and don’t always work properly! (especially for Forms and Reports). Instead, they seem to return the Created Date/Time again.…
Continue reading →
In it, I detailed that the Last Modified properties was in fact unreliable and hence there was a bug.
So, at the end of the article, I included a link to a Feedback Portal suggestion I created about the issue in the hopes Microsoft would decided to fix this issue for us all.
Continue reading →