Dear Access:



We are using the Wrox  ASP 3.0 Programmer's Reference book. We are in

chapter 26 using the examples for accessing stored procedures parameters and

updating the Miscrosoft SQL Server database tables using stored procedures

as in the example on page 405. That works great with MSSQL Server, but when you

try to do it with MS Access it draws errors. ---->>>>AS FOLLOWS-->>



______________________________________________________________________

Microsoft JET Database Engine error '80040e21'



Multiple-step OLE DB operation generated errors. Check each OLE DB status

value, if available. No work was done.



/asp/storproc_access_vbs.asp, line 47

____________________________________________________________________



It seems that the stored queries in Access that use parameters are not

running right possibly because of a character type problem(I don't know for

sure). MS ACCESS

doesn't have VarChar, Char, Integer, etc.



I can run a stored query from MS ACCESS using the code in the book as long

as it does not expect parameters (select statements).

ALSO---->>>>>>>

When I run the helper program from page 403-404 in the book in MS SQL Server

stored procedures it returns the proper parameters datatypes, size,

direction, and name, but when I try to run it on MS ACCESS procedures with

a stored procedure (query) with parameters it just returns a blank table

with no information and no error messages.



Can you help me figure this out, or is there a way to do it using Access?



Thank you;



Cullan Crothers

cullan.crothers@w...