CmdQry.CommandType = adCmdStoredProc -- wrong command type ... you should have used adCmdTable or adCmdText .... a query is a query or a view, not a stored proc.

-tg