下面是个简单易学的通过查询返回access数据库对象的名称教程，图老师小编详细图解介绍包你轻松学会，喜欢的朋友赶紧get起来吧！
【 tulaoshi.com - 编程语言 】
使用下列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;
（本文来源于图老师网站，更多请访问https://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;
来源:https://www.tulaoshi.com/n/20160219/1620049.html
看过《通过查询返回access数据库对象的名称》的人还看了以下文章 更多>>
