Microsoft Access 上次修改日期 [英] Microsoft Access Last modified date

问题描述

我需要知道我上次在 microsoft access 上修改我的数据库是什么时候，但是因为我今天打开它，它改变了日期.有没有办法事先查明我上次修改它的时间?

I need to know when I last modified my database on microsoft access, but because I opened it today, it had changed the date. Is there a way to find out when I last modified it before hand?

推荐答案

大概吧.查看系统表 MSysObjects.在 DateUpdate 字段中查找最近日期的记录.只需快速排序最新到最旧.但是，在编辑通用代码模块时似乎没有跟踪.

Sort of, maybe. Look at system table MSysObjects. Find record with most recent date in DateUpdate field. Just do a quick sort Newest to Oldest. However, doesn't seem to track when general code modules are edited.

系统表默认是隐藏的.通过右键单击导航页面取消隐藏>所有访问对象 >导航选项 >选择选项.

System tables are hidden by default. Unhide by right click on Navigation Page > All Access Objects > Navigation Options > select options.

或

在 Access 2010 及更高版本中，可以通过以下方式使系统表可见:

In Access 2010 and later System tables can be made visible by going:

文件 >选项 >当前数据库导航导航选项... >显示系统对象

File > Options > Current Database > Navigation > Navigation Options... > Show System Objects

或者不要取消隐藏，只需构建一个查询:
SELECT * FROM MSysObjects ORDER BY DateUpdate DESC;

Or instead of unhiding, just build a query:
SELECT * FROM MSysObjects ORDER BY DateUpdate DESC;

这篇关于Microsoft Access 上次修改日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！