Access显示数据表链接表查询等对象SQL语句（数据表及查询是access数据库的）

'各种对象SQL语句：

'本地表+Access链接表：Select Name FROM MSysObjects Where (Flags=0) AND (Type=1) or (Type = 6)
'本地表+Access链接表 +SQL 链接表：Select Name FROM MSysObjects Where (Flags=1048576) or (Flags=0)

AND (Type=1) or (Type=4) or (Type=6) orDER BY MSysObjects.Name;

'本地表：Select Name FROM MSysObjects Where (Flags=0) AND (Type=1)

'Access链接表：Select Name FROM MSysObjects Where ((([Type])=6));

'Access链接表+SQL Server链接表：Select Name FROM MSysObjects Where (((Name) Not Like "~TMP*") AND ((Type)=4)) or (((Type)=6));

'查询：Select Name FROM MSysObjects Where (Flags=0) and (Type = 5)
'窗体：Select Name FROM MSysObjects Where flags=0 and type =-32768
'模块：Select Name FROM MSysObjects Where flags=0 and type =-32761
'报表：Select Name FROM MSysObjects Where (Flags=0) AND (Type=-32764);
'宏：Select Name FROM MSysObjects Where flags=0 and type =-32766

阅读原文：http://www.accessoft.com/article-show.asp?id=20088