MS Access 2013对象(表，查询)显示创建或修改的日期 [英] MS Access 2013 objects (tables, queries) display created or modified date

问题描述

有什么方法可以使 Access 2013 显示created和modified date? Access 2003 用于显示这些功能，并且似乎找不到 Access 2013 的任何解决方案?

Is there any way I can make Access 2013 display created and modified date? Access 2003 used to display those features and can't seem to find any solution to Access 2013?

推荐答案

您可以右键单击对象列表标题，然后进行查看->详细信息.但这仍然不是一个很好的概述.

You can right-click the object list header, and do View -> Details. But that's still not a very good overview.

(哦，我怎么会错过Access 2003数据库窗口...)

(Oh how I miss the Access 2003 database window...)

更好的方法是查询MSysObjects表，例如:

A better way is to query the MSysObjects table, e.g.:

SELECT MSysObjects.Type, MSysObjects.Name, MSysObjects.DateUpdate, MSysObjects.DateCreate
FROM MSysObjects
WHERE (((MSysObjects.Type)<>2 And (MSysObjects.Type)<>3 And (MSysObjects.Type)<>-32757) 
  AND ((Left([Name],1))<>'~') AND ((Left([Name],4))<>'Msys'))
ORDER BY MSysObjects.Type, MSysObjects.Name;

有关对象类型常量，请参见此处:
MsysObjects值-32758，-32757和3的含义( Microsoft Access)

See here for the object type constants:
Meaning of MsysObjects values -32758, -32757 and 3 (Microsoft Access)

您可能也对该免费的数据库窗口替换"加载项感兴趣:
http://www.avenius.de/index.php?Produkte:DBC2007

You may also be interested in this free "Database window replacement" add-in:
http://www.avenius.de/index.php?Produkte:DBC2007

这篇关于MS Access 2013对象(表，查询)显示创建或修改的日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！