Re[4]: [PHP4BETA] Stored Procedures and ODBC

AG> In the help file for Access there is a discussion of the PROCEDURE clause. It AG> seems that in addition to SELECT, UPDATE, DELETE and CREATE there is something AG> called CREATE PROCEDURE and PROCEDURE. The Access help is somewhat unclear, but AG> you might want to look at it and try out the commands. If they do work as I AG> think they might, you statement would be something like AG> odbc_exec("PROCEDURE...") with the name of the procedure and its parameters AG> filling in the dots. AG> -------------------------------------------------- AG> Avrum Goodblatt goodblat@sprynet.com (415) 9451368 AG> http://home.sprynet.com/~goodblat It seems to work this way: $conn_id = odbc_connect( "odbc_test_db", "", "", SQL_CUR_USE_DRIVER ); $qry_id = odbc_do( $conn_id, "{CALL MyQuery}" ); where MyQuery is the name of the query stored in the MS Access db. Thanks for the hints! Frank.