I have an MSAccess database that I have created the following query:
SELECT Members.*, [theInput] AS InputVal FROM Members
So when I run this in Access an alert pops requesting 'Enter Parameter Value' requesting a value for theInput . So I type a value in that and everything works splendidly.
Can anyone tell me how to include a parameter in my ASP SQL to pass to Access for the value in InputVal so I don't get a 'No value given for one or more required parameters.' error from the JET Database Engine?
Not sure if you have an answer for your question, but it is rather easy. Just remember to input the paramters in the order they are listed in your query. Also, use quotes for parameters that are strings, dates, etc. You don't have to use quotes for paramters that are numbers.
Set objRs = objConn.Execute ("exec query_name param1, param2, param3")
You can list as many parameters as you have, just seperate them by commas.