Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbc-msAccess

 
med bill
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 161
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
med bill
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks guys..
it works for me...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic