Access Related Query

  • Thread starter Thread starter Kishor
  • Start date Start date
K

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
 
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.
 
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
 
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.
 
¤ 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)
 
Back
Top