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).]
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
Joined: Aug 02, 2001
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!