aspose file tools*
The moose likes General Computing and the fly likes How to run multiple query in MS Access? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Engineering » General Computing
Bookmark "How to run multiple query in MS Access?" Watch "How to run multiple query in MS Access?" New topic
Author

How to run multiple query in MS Access?

Elahe Shafie
Ranch Hand

Joined: Dec 12, 2001
Posts: 291
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

Joined: Apr 24, 2002
Posts: 137
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 ]

use the [CODE] tags - it makes it much easier for people to help you.
Elahe Shafie
Ranch Hand

Joined: Dec 12, 2001
Posts: 291
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

Joined: Feb 20, 2001
Posts: 3695

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

Joined: Dec 12, 2001
Posts: 291
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

Joined: Mar 15, 2005
Posts: 2
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

Joined: Mar 15, 2005
Posts: 2
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to run multiple query in MS Access?
 
Similar Threads
SQL syntax for displaying the total count of tables from a database
Problem with Like statement Using JDBC:ODBC
how to enter date object in ms access database
Connecting to MS Access using Oracle stored procedures and JDBC
JDBC supported SQL functions