JET 4 supports ANSI 92 Extensions so you can use the EXECUTE clause for stored proceedures in the below syntax:
(SomeProceedure is a query with one parameter as criteria)
Conn.Execute "EXECUTE SomeProceedure 'abc'"
or
Set rsADO = conn.Execute ("EXECUTE SomeProceedure 'abc'"
or
rsADO.Open ("EXECUTE SomeProceedure 'abc'"
JET 4 also supports:
CREATE PROCEDURE
CREATE VIEW
DROP PROCEDURE
DROP VIEW
CREATE PROC[EDURE] procedure [(param1 datatype1 [, param2 datatype2 [, ...] ])] AS sql-statement;
EXEC[UTE] procedure [param1 [, param2 [, ...] ]] ;
DROP PROC[EDURE] procedure;
CREATE VIEW view [(field1 [, field2 [,...] ])] AS select-statement;
DROP VIEW view;