The following SQL statement can be used to produce a list of all the queries within a given MS Access database.
SELECT MsysObjects.Name AS [List OF Queries] FROM MsysObjects WHERE (((MsysObjects.Name) NOT LIKE "~*" AND (MsysObjects.Name) NOT LIKE "MSys*") AND ((MsysObjects.TYPE)=5)) ORDER BY MsysObjects.Name;
Thursday, June 10th, 2010, 8:09 pm | 
MS Access Queries | 
RSS feed
Pinging is disabled. But you can skip to the end and leave a 
response.