LogoASPAlliance: Articles, reviews, and samples for .NET Developers
Access 2000 Stored Procedures
by Andrew Mooney
Average Rating: 
Views (Total / Last 10 Days): 14174/ 32

Using Stored Procedures, called Parameter Queries, in Access 2000

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 ]

©Copyright 1998-2020  |  Page Processed at 2020-08-08 11:02:17 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search