Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MSACCESS Connection

 
Paul McKenna
Ugly Redneck
Ranch Hand
Posts: 1006
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic