Use SQL to List all Queries in DB 2

[Kazim]

I am using ADO in a VB app to list the queries found in an Access database (Specified by the user at runtime)

I was wondering if there was an SQL statement which could be passed which would do the same thing?

Any help please... Thanks

Kazim

 

[Rizla]

This should do it
SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Type)=5));

 

[Kazim]

Rizla:

Many thanks - I am on it right now!