File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jdbc-msAccess
 
Similar Threads
Accessing table names in MSAccess
How to connect msaccess database from myeclipse IDE tools
Driver for MSAccess
Which SQL Statement should use for that??
Details about CMP bean deployement discriptor