Hi,

I am going through some serious problem with ms access queries. I am trying to run multiple statements on ms access database in the "SQL View".

Moreover when I try to solve this problem through recordsets in ASP 3.0, I experience the same problem.

the error is thrown "characters found after the end of SQL statement"

I want to run 2 statements one after another on the same record set execution.

Example:

select * from temp; drop table temp;

its not working. ..eeeeh

why the hell ms access does not support multiple statements.

can anyone help me on this..

thanks,
Danish