Cullan,



I've been struggling with the same issues myself lately. I offer this not as

expert advice, but more as something to look into. I think it's safe to say

the Access doesn't use stored procedures, but instead uses stored queries.

Unfortunately, I cannot explain the difference, but it may be enough to make

the code from the book not work. I did find an interesting tutorial online

about using stored queries (from an Access DB) in ASP. Give 'er a look and

see what you think:



http://stardeveloper.com:8080/articles/010701-1.shtml



Regards,

Josh.



"Cullan Crothers" <cullan.crothers@w...> wrote in message

news:40168@a...

>

> Dear Access:

>

> Please  help me with ASP passing parameters to stored procedures with

parameters from a MS

> ACCESS database

> as in chapter 26 of the ASP 3.0 Prog Reference Book. The examples on pages

404-406, etc.

> work fine with MS SQL Server, but I can only get a basic select * stored

query from MSACCESS

> to work with it. The Access stored queries with parameters (like an insert

statement) do not

> return any parameter values and do not work. How do you phrase ASP to pass

the

> parameters to an ACCESS database? There seems to be a problem with ASP

reading the

> proper datatype, size, etc. from the Access queries.

>

> Thanks;

>

> Cullan Crothers

> cullan.crothers@w...

>

>