List all Access queries

[martin]

Hi,

I am displaying informtion from an access database on the aspx pages of my
intranet.
This is no problem, except am stuck on the follwoing point and would
appreciate a little help.

I have a few predined queries in ms access,
what I would like to do is the follwoing
1. Display a list of all queries in my web page.
2. Display a list of all queries starting with the letter M

I am mostly pondering how I would actuall write a query that in effect
retrieve a list of predefined queries from MS Access.

Any help on this matter is appreciated.

Thanks in advance.

cheers

martin.

 

[Natty Gur]

Hi,

the following query will return all queries in you Access DB :

Select Name from MSysObjects Where Type = 5 And Flags = 0 order by Name

HTH

Natty Gur[MVP]

blog : http://weblogs.asp.net/ngur
Mobile: +972-(0)58-888377

 

[martin]

Thanks