Access Related Query

[Kishor]

Hi,

I am using Access as a backend to my project. From my front end I am issuing
the queries, however I am finding it is too much slow. I wanted to execute
multiple sql statement. My question here is how to execute these multiple
statement?. Is it possible in acess 2000. can I have your suggestions?.



TIA

Kishor

 

[Roman S. Golubin1709176985]

Hi, Kishor!

I am using Access as a backend to my project. From my front end I am issuing
the queries, however I am finding it is too much slow. I wanted to execute
multiple sql statement. My question here is how to execute these multiple
statement?. Is it possible in acess 2000. can I have your suggestions?.

select * from T1; select * from T2; select * from T3;


--
WBR, Roman S. Golubin
ICQ UIN 63253392
(e-mail address removed)

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Kishor]

hi Golubin,
This is not working for insert statement. I wanted to insert data in to a
table via single sql statement. Sql statement would contain multiple insert
statement.


Thanks
Kishor

 

[John Vinson]

Hi,

I am using Access as a backend to my project. From my front end I am issuing
the queries, however I am finding it is too much slow. I wanted to execute
multiple sql statement. My question here is how to execute these multiple
statement?. Is it possible in acess 2000. can I have your suggestions?.

JET SQL does not permit multiple SQL operations in one query. You
simply cannot do this with a multistatement Query if the backend is in
an Access .mdb file.

If you're using an ADP file (using MSDE, basically SQL/Server) then
you can use a SQL Passthrough Query, since SQL/Server does permit
multiple statements. If not, you'll need to use VBA to execute the
queries one at a time.

Newsgroups trimmed... therefor posted & emailed. Please reply in
m.p.a.tablesdbdesign.

 

[Paul Clement]

¤ hi Golubin,
¤ This is not working for insert statement. I wanted to insert data in to a
¤ table via single sql statement. Sql statement would contain multiple insert
¤ statement.
¤

Have you tried using QueryDefs with parameters instead?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)