passing variable to access stored procedure

[exc]

i have a stored procedure (a query) in an access database. i want to pass a variable from an asp form to this query to filter the query.

i suspect that the criteria portion of the query will be part of the solution but i just can't get it to work...

anyone have some suggestions or experience in this area.

eric
eciminski@graham.az.gov

 

[vasah20]

You can do it by using the command object.

here's a link with some source code for you to check out:

http://www.4guysfromrolla.com/webtech/021799-1.shtml

hope this helps
leo

 

[jonscott8]

There are also other threads here that discuss this topic, do a keyword search for Access and Parameter. Jon Hawkins