Stored procedures offer many advantages like single command database operations, better performance, and additional security. Stored procedures, called Parameter Queries, can be used with Access databases starting with the 2000 version. Unlike SQL Server Stored Procedures, Access Parameter Queries do not support multiple operations or output parameters. One quirk you need to be aware of is that Access will assign the first parameter from your code to the first parameter actually listed in the parameter query. What this means is that Access ignores the names you give parameters in your code and assigns them in order. For more information see Parameter Query Explanation under View Source below. The download contains all of the files used in the online sample in both C#.NET and VB.NET and an Access 2000 databse containing the parameter queries. The online sample does not allow parameter queries to execute.
[ Run Sample ] | [ View Source ] | [ Download ]