I am trying to retrive names of all stored procedures
(queries) from MS Access 2000 database. I use OpenSchema
method with query type adSchemaProcedures. I get a
recordset with queries' names but not all are present that
are actualy in the database. I checked one of the queries
that I am looking for in the database - it looks like any
other select query whose name does come up (property wise
and everything). Has anyone dealt with this before, please
help! Oh yes, also the record count for the recordset
comes out to be -1. Why? here some code might help

Set rstSchema = cnn1.OpenSchema(adSchemaProcedures)
rstSchema.MoveFirst
MsgBox "number of procedures: " & rstSchema.RecordCount
Do Until rstSchema.EOF
    cmbQueries.AddItem (rstSchema!PROCEDURE_NAME)
    rstSchema.MoveNext
Loop
rstSchema.Close

thanks a lot in advance.