This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes JDBC 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 Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "HELP!!! " Watch "HELP!!! " New topic
Author

HELP!!!

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
Greenhorn

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"
Gary
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 (www.mysql.com) 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: http://aspose.com/file-tools
 
subject: HELP!!!
 
Similar Threads
Maybe a First! Got my results in 6 days :)
posting a question on coderanch
How to create a Database?
Applet and JDBC
Appet with data Base