OK, but I would like to use a parameter crosstab query with MS-Access.
When I use a stored procedure, I can't use parameters !

Thanks for your answer.



------------
Frank Kwong at 6/24/00 10:35:48 PM

you have to treat the query as a stored procedure. This process is slow so use it when you have absolute no control of the data asource.

FK



------------



Hi,

How does ASP-db work with an MS-Access crosstab-query ?

It seems that ASP-db doesn't accept a SQL string containing
a crosstab-query with the dbSQL property.

Thanks for your answer.