jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes Netbeans and MS Access 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 "Netbeans and MS Access" Watch "Netbeans and MS Access" New topic

Netbeans and MS Access

catherine matthews
Ranch Hand

Joined: Jan 22, 2006
Posts: 78
I could not find much help on how to create dateabse connection with netbeans.

I am trying to access tables in MS Access using the netbeans. Can anyone help??

I tried to add the driver from
Runtime-database-drivers-(JDBC-ODBC-DRIVER)-Connect Using
Database URL : jdbc dbc:<DB>

the DB part i put in d:/java/db4.mdb- the path where my database file is
But i could not make a connection

When i run the code below using a command prompt There is no problem

Stuart Smith
Ranch Hand

Joined: Mar 28, 2008
Posts: 54
Java will connect as its loading a file via JDBC have you added a ODBC connection from the control panel in administrative tools?

As once you have done that Netbeans will be able to find it.
check here http://wiki.netbeans.org/AccessMssql google is your friend

Dale Carnegie:<br />"Most of the important things in the world have been accomplished<br />by people who have kept on trying when there seemed to be no hope at all."
I agree. Here's the link: http://aspose.com/file-tools
subject: Netbeans and MS Access
It's not a secret anymore!