This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 and Relational Databases
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: MSACCESS Connection
 
It's not a secret anymore!