今天图老师小编给大家精心推荐个如何获取Access系统表教程，一起来看看过程究竟如何进行吧！喜欢还请点个赞哦~
【 tulaoshi.com - 编程语言 】
Access 系统表 MsysObjects 包含了数据库对象列表, 尽管未在文档中记载, 你仍可通过查询它来获取你想要的.
（本文来源于图老师网站，更多请访问http://www.tulaoshi.com/bianchengyuyan/）注: 请不要有意或无意地修改任何ACCESS系统表,否则会出现不可意料的情况.
使用下列 SQL 语句来获取你想要的
查询:
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)"~") AND (MSysObjects.Type)=5 ORDER BY MSysObjects.Name;
窗体:
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)"~") AND (MSysObjects.Type)=-32768 ORDER BY MSysObjects.Name;
表:
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)"~") AND (Left$([Name],4) "Msys") AND (MSysObjects.Type)=1 ORDER BY MSysObjects.Name;
（本文来源于图老师网站，更多请访问http://www.tulaoshi.com/bianchengyuyan/）报表:
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)"~") AND (MSysObjects.Type)= -32764 ORDER BY MSysObjects.Name;
模块:
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)"~") AND (MSysObjects.Type)= -32761 ORDER BY MSysObjects.Name;
宏:
SELECT MSysObjects.Name FROM MsysObjects WHERE (Left([Name],1)"~") AND (MSysObjects.Type)= -32766 ORDER BY MSysObjects.Name;
来源:http://www.tulaoshi.com/n/20160219/1610505.html
看过《如何获取Access系统表》的人还看了以下文章 更多>>
