I followed the code as indicated in the Subject line to the letter, but 

for some reason when I view the page it just times out... no errrors 

regarding syntax, DB connectivity, etc. Just a suggestion to adjust the 

server time out value. Basically, I'm trying to pass a paramater to an 

Access Query using the command object. Is it possible? Here is my 

variation of the code if anyone is interested:



Dim objComm, objParam, objRS, strEMail



strEmail = Request.Form("EMail")

	

Set objComm = Server.CreateObject("ADODB.Command")

objComm.ActiveConnection = strConn 'strConn is an Access OLE DB connection

objComm.CommandText = "qryListOrd"

objComm.CommandType = adCmdStoredProc

	

Set objParam = objComm.CreateParameter("Required EMail", adVarChar, 

adParamInput, 50, strEMail)

objComm.Parameters.Append objParam

	

Set objRS = objComm.Execute



.

.

.



It then goes on to iterate thru the Record Set and clean up the objects 

etc.



Any help would be greatly appreciated.



Steve