1、参考ADO的OPENSCHEMA、用ADOX的TABLES,如用管理员身份登录,
SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.ParentId)=251658241) AND ((MSysObjects.Type)=1) AND ((Left([MSysObjects].[Name],4)) <>"MSys"));
2、select * from tt where 1>2;
3、Access不是SQL Server,没有系统表,只有用代码取得列名及类型
Access 的SQL
Table list in Access , MSysObjects is the system table !
SQL code
SELECT Name FROM MSysObjects WHERE Type=1