Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to run multiple query in MS Access?

 
Elahe Shafie
Ranch Hand
Posts: 291
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Friends,
I am trying to run several queries and I like to make a procedure and put those query there and just call that procedure name to run it how it that possible in MS Access?I mean can I create procedure?or something like that which treats me the same as procedure?
Many thanks for your help,
Elham
 
Jon Dornback
Ranch Hand
Posts: 137
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
if you absolutely must use access, you can create queries inside access and call those from your jdbc connection. or, you can build a function inside your java class that makes the necessary calls. i'm not sure if the jdbcdbc->access driver supports it, but you should use the Connection.setAutoCommit(false) before making transactions, then back to true when you are done.
[ November 01, 2002: Message edited by: Jon Dornback ]
 
Elahe Shafie
Ranch Hand
Posts: 291
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My question is when I am in MS Access without using Java or connect to any thing just at the level of MS ACCESS.
I mean how can I run multiple query inside the MS ACCESS?
Thanks for your help and hope to hear from you so soon.
Elham
 
Mike Curwen
Ranch Hand
Posts: 3695
IntelliJ IDE Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you mean.. 'build a single result set out of the results of multiple queries', then investigate the UNION SQL keyword.

If you mean.. 'make multiple, unrelated queries in a transaction', then yes, you can use macros to do this.
 
Elahe Shafie
Ranch Hand
Posts: 291
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
THANK YOU SO MUCH MIKE and may I have sample script for marcro to see how can I write it in order to run two query together?I mean some hint...
Really appreciate your hep,
Elahe
 
white_wolf
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by elahe shafie:
THANK YOU SO MUCH MIKE and may I have sample script for marcro to see how can I write it in order to run two query together?I mean some hint...

Really appreciate your hep,
Elahe
 
white_wolf
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HI ALL
I HAVE THE SAME PROBLEM WILL U GIVE US SOME NOTES OF HOW MAKE A MACRO OR
WRITE A SECREPT FOR THAT

THANK U IN ADVANCE
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic