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
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 jdbc:odbc->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.
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