Note that stored procedures are often more efficient than defining a query with adCmdText, because the database can preprocess the procedure, and execution can be faster. However, you do need additional access rights on the database to create new stored procedures.