This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes HELP!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "HELP!!! " Watch "HELP!!! " New topic


fengzixuan zheng
Ranch Hand

Joined: Aug 02, 2001
Posts: 31
I got a problem, I want connect to a MS Access database, and I found when I get connected, I only can use the READ_ONLY concurrency, HOW I CAN MODIFY the Access database? Help. Please.
By the way, can I create a connection without building a 32-bits database source in the Windows, I need to imagrate the app programs to another computer.
Thanks !
[This message has been edited by fengzixuan zheng (edited August 18, 2001).]
Gary Labowitz

Joined: Aug 18, 2001
Posts: 5
Use CONCUR_UPDATABLE constant in the createStatement() method. This is only since 1.2, so if you are using the jdbc/odbc driver from 1.1x you are out of luck.
BTW, you don't even need a DSN; just use
url = "jdbc dbc:MS Access Database;DBQ=path-to-database"
fengzixuan zheng
Ranch Hand

Joined: Aug 02, 2001
Posts: 31
THANK U, Labowitz
But I'm using JDK1.3, I will try again .
What database do U suggest to use when developing a databased-project ?
Thank U again!
Stanley Tan
Ranch Hand

Joined: May 17, 2001
Posts: 243
For small projects, MS Access will do fine. But I would suggest using MySQL ( because it's lightning fast and it's FREE too (and it works on both Windows and *nix).
Good luck!
I agree. Here's the link:
subject: HELP!!!
jQuery in Action, 3rd edition