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 HELP!!! 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 "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!!!
It's not a secret anymore!