How to list queries by type

You can get a list of all queries with simple select statement:

SELECT Name
FROM MSysObjects
WHERE Type=5

There is a Flags field in MSysObjects which shows query type, for example you can get a list of all pass-through queries:

SELECT Name
FROM MSysObjects
WHERE MSysObjects.Type=5 AND Flags in (112, 144)

And here a list of flags field values you can use (at least what i found):

• 0 – Select query
• 3 – hidden select query, used in form’s recordsource or control’s rowsource
• 16 – Crosstab query
• 32 – Delete query
• 48 – Update query
• 64 – Append query
• 80 - Make-Table query
• 96 – DDL query
• 112 - Pass-through Select query
• 128 – Union query
• 144 - Pass-through Action query