aspose file tools*
The moose likes JDBC and the fly likes MSACCESS Connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MSACCESS Connection" Watch "MSACCESS Connection" New topic
Author

MSACCESS Connection

Paul McKenna
Ugly Redneck
Ranch Hand

Joined: Jul 08, 2000
Posts: 1006
Could someone please explain how to connect to the MS Access Database using JDBC completely. I am really frustrated using JDBC. I tried using the Microsoft Text Driver for a simple databse and the error I recieved was : " Cannot Create Table, The Databse is in a Read Only Mode"
Any explanations???
Thanks In Advance!


Commentary From the Sidelines of history
Anonymous
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
To connect to MS Access you have to create a DSN first.Assuming you are using Windows 98 or above,
Select control panel from Windows menu, Select ODBC. Follow the directions to create a new Data Source Name selecting MSAccess driver and add it to the list of DSNs.
A good first lesson in JDBC is 'Duke's Bakery' provided in Sun's tutorials.Check it out.


Originally posted by Sriraj Rajaram:
Could someone please explain how to connect to the MS Access Database using JDBC completely. I am really frustrated using JDBC. I tried using the Microsoft Text Driver for a simple databse and the error I recieved was : " Cannot Create Table, The Databse is in a Read Only Mode"
Any explanations???
Thanks In Advance!

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MSACCESS Connection