File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "jdbc-msAccess" Watch "jdbc-msAccess" New topic


med bill

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

Joined: Oct 27, 2000
Posts: 12
Thanks guys..
it works for me...
I agree. Here's the link:
subject: jdbc-msAccess
It's not a secret anymore!