Display a list of database objects
ALL FORMS:
SELECT [MSysObjects].[Name]
FROM MSysObjects
WHERE (Left([Name],1)<>"~") And ([MSysObjects].[Type])=-32768
ORDER BY [MSysObjects].[Name];
ALL REPORTS:
SELECT [MSysObjects].[Name]
FROM MSysObjects
WHERE (((Left([Name],1))<>"~") AND ((MSysObjects.Type)=-32764))
ORDER BY MSysObjects.Name;
ALL QUERIES:
SELECT [MSysObjects].[Name]
FROM MSysObjects
WHERE (((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5))
ORDER BY MSysObjects.Name;
ALL TABLES [1 = System & Access, 4 = ODBC & 6 = Access]:
SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((Left([Name],1))<>"~") AND ((MSysObjects.Type) In (1,4,6)))
ORDER BY MSysObjects.Name;
LINKED TABLES [4 = ODBC, 6 = Access]:
SELECT MSysObjects.Name, MSysObjects.Database
FROM MSysObjects
WHERE (((Left([Name],1))<>"~") AND ((MSysObjects.Type) In (4,6)))
ORDER BY MSysObjects.Name;
ALL MODULES [forms, macros, modules]:
SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((Left([Name],1))<>"~") AND ((MSysObjects.Type) In (-32761,3)))
ORDER BY MSysObjects.Name;
PUBLIC MODULES
SELECT [MSysObjects].[Name]
FROM MSysObjects
WHERE (((Left([Name],1))<>"~") AND ((MSysObjects.Type)=-32761))
ORDER BY MSysObjects.Name;