aspose file tools*
The moose likes JDBC and the fly likes jdbc-msAccess Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jdbc-msAccess" Watch "jdbc-msAccess" New topic
Author

jdbc-msAccess

med bill
Greenhorn

Joined: Oct 27, 2000
Posts: 12
i have problems querying tables using sql Join type with jdbc on MsAccess. Does MsAccess use diferent SQL type commands, do u know where can i get it.
I am trying to develop some appl. that use JDBC against an Ms Access database. thanks
Joe Paolangeli
Ranch Hand

Joined: Apr 05, 2000
Posts: 73
I have coded table joins using JDBC and MS Access. I found that was very usefull to first develop a query in MS Access to fix any possible syntax errors. Here is a sample table join query:

Let me know if this helps.
[This message has been edited by Joe Paolangeli (edited October 27, 2000).]
Monty Ireland
Ranch Hand

Joined: Oct 03, 2000
Posts: 161
Any basic DML sql should work...
I you are using the jdbc-odbc driver provider with the standard jdk. Take a few minutes to review the demo/sample code.
Or, search this form for jdbc-odbc sample code.
Go back about 60 days... you will find alot of complete program examples.

------------------
We learn more from our mistake's than from our success's.
a.k.a. monty6


Multi Platform Database Developer & DBA on E.S.T.
med bill
Greenhorn

Joined: Oct 27, 2000
Posts: 12
Thanks guys..
it works for me...
 
Don't get me started about those stupid light bulbs.
 
subject: jdbc-msAccess