I believe you can by executing the scripts to create the stored procedure from your program. But I can't understand why you would want to do that. It would really slow the process down. You can pass variables along with the stored procedure name to the data base to make the SP dynamic. However, my experience is with SQL-Server, not Access.