ado stored query

[bartb]

Hi

Im using the ado toolkit, its works fine. NBut i have a problem. I read the stored querys in my acces database. But i also want to use those querys. How do i do this? Can I read the SQL code of the stored query or is there an other option or is t impossible.

Bart

[DavidJCrawford]

You can use the queries in MS Access as you would any other table e.g. SELECT qryTestDist1.* FROM qryTestDist1; where qryTestDist1 is a saved query.

Does that help?

Daviid

[bartb]

is qryTestDist1 the name of the saved query?

[DavidJCrawford]

Yes. E.g. I am working in Access and created a query using the query builder and saved it as qryTestDist1 in the Queries tab. Make sense?

[bartb]

dus how exactly does my query string should look like if my query is called "test"

[DavidJCrawford]

SELECT * FROM test;