I have this error message-

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

[Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented

/VBStyle/basket.asp, line 252

I am trying to use the Command ADO object to run PARAMETER queries in MS
Access 97.Can MS Access run PARAMETER queries in conjunction with the ADO
Command
methods, and simulate stored procedures?

The line 252 is cmd.Execute below. If I need to add any args to that, please
let me know. Failing that though, um, can Access work as the db backend for
this sort of code (the following)? I read somewhere that Access might not
support this. Also below is the text of the "stored procedure". Please help
with any detail , I would be grateful.

Cheers
Justin Dutoit

set conn = server.CreateObject("ADODB.Connection")
conn.Open "vbstyle"

set param = server.CreateObject("ADODB.Parameter")
set cmd = server.CreateObject("ADODB.Command")

With cmd
Set .ActiveConnection = conn
.CommandText = "sproc_getbaskettotal"
.CommandType = adCmdStoredProc           ' Public Const adCmdStoredProc =
&H0004
.Parameters.Append .CreateParameter("basketnum",adBigInt)
.Parameters("basketnum").Value = basketnumber
.Parameters.Append .CreateParameter("thetotal",adDouble)
end with
cmd.Execute
thetotal = cmd.Parameters("thetotal").Value
..
..
PARAMETERS [basketnum] Long, [thetotal] IEEEDouble;
SELECT basketnumber, total AS thetotal
FROM baskets
WHERE basketnumber=[basketnum];