[AccessD] List Queries

Gary Kjos garykjos at hotmail.com
Fri May 7 09:26:18 CDT 2004


Just do a query on MSysObjects table

SELECT MSysObjects.Type, MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=5))
ORDER BY MSysObjects.Name;

Gary Kjos
garykjos at hotmail.com





>From: paul.hartland at fsmail.net
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: accessd <accessd at databaseadvisors.com>
>Subject: [AccessD] List Queries
>Date: Fri,  7 May 2004 12:19:46 +0200 (CEST)
>
>To all,
>Gone totally brain dead, I want to print a list of all my queries in a 
>database (500+) I only want the names and Documenter don't cater for this.  
>So has anyone got any sample code for the QueryDef object that I could 
>probably get a list that way ?
>Thanks in advance
>Paul
>
>--
>
>Whatever you Wanadoo:
>http://www.wanadoo.co.uk/time/
>
>This email has been checked for most known viruses - find out more at: 
>http://www.wanadoo.co.uk/help/id/7098.htm
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com





More information about the AccessD mailing list