Parameterized queries are a great asset when developing database applications.
They allow you to modularize your code, so that it's easier to read and maintain. Another great benefit of parameterized queries is that they run faster than queries which you explicity type in each time. Here is a sample for a parameterized stored procedure in MS Access. Dim tmpFields Dim strName Dim strTable ' Open connection. While Not rstNyttSvarID.EOF Response.