multiple recordsets in ms access

[Guest]

h
i m tring to create multiple recordsets from ms access thru vb.ne
my string i
str="select name from jobs;select col2 from jobs
but it gves me erro
"Characters found after end of SQL statement
wat to d
amrita
thnx

 

[Miha Markic]

Hi,

OleDb managed provider/Jet driver doesn't support multiple stataments.

 

[Guest]

so whats the way out if i want multiple queries in msacces

----- Miha Markic wrote: ----

Hi

OleDb managed provider/Jet driver doesn't support multiple stataments

 

[Miha Markic]

Run multiple ExecuteXXX stataments one by one.