MS Access 2013 objects (tables, queries) display created or modified date -
is there way can make access 2013 display created
, modified date
? access 2003 used display features , can't seem find solution access 2013?
you can right-click object list header, , view -> details. that's still not overview.
(oh how miss access 2003 database window...)
a better way query msysobjects
table, e.g.:
select msysobjects.type, msysobjects.name, msysobjects.dateupdate, msysobjects.datecreate msysobjects (((msysobjects.type)<>2 , (msysobjects.type)<>3 , (msysobjects.type)<>-32757) , ((left([name],1))<>'~') , ((left([name],4))<>'msys')) order msysobjects.type, msysobjects.name;
see here object type constants:
meaning of msysobjects values -32758, -32757 , 3 (microsoft access)
you may interested in free "database window replacement" add-in:
http://www.avenius.de/index.php?produkte:dbc2007
Comments
Post a Comment