Start a new topic

Creating a connection to a MS Access (accdb) file

[This topic is migrated from our old forums. The original author name has been removed]

Hey All, I'm really new to this and was wondering how to use a database that I created using MS access to write queries in DB vis. I don't really know how to set this up. I saw that it is recognized first in my screen shot below. Just looking for some help, as I'm really new to this and the terminology. Thanks in advance.

1 person has this question

[This reply is migrated from our old forums.]

Re: Creating a connection to a MS Access (accdb) file
Daniel, You should use the JDBC-ODBC bridge driver in DbVisualizer to connect to MS Access. Easiest is to launch the Tools->Connection Wizard to create the database connection. You mention a screenshot but it was not attached to your post. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Creating a connection to a MS Access (accdb) file


question


Anybody have answer?
[This reply is migrated from our old forums.]

Re: Creating a connection to a MS Access (accdb) file
Did you try Roger's suggestion? If it didn't work, what error message did you get? Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: Creating a connection to a MS Access (accdb) file
The file type MDB has been created by MS Access 97 (Office 8) till MS Access 2003 (Office 11). It can be handled with the database engine ?Jet 4.0?. MS Access 2007 (Office 12) uses the file type ACCDB. It uses a modified Jet database engine, called ?Access Database Engine? (ACE) [url=http://goo.gl/maoapk].[/url] If you would like to create the ?.mdb? file through java, you can use the Jackcess Java library which is one of the pure Java Library for reading from and writing to MS Access databases. Currently supporting versions include 2000-2007 I guess. Please have a look at the below example for better understanding: Download Jackcess Java library (jackcess-1.2.6.jar) from http://jackcess.sourceforge.net/ and commons-logging-1.1.jar from http://commons.apache.org/logging/download_logging.cgi and commons-lang-2.0.jar from http://www.findjar.com/index.x?query=commons-lang Add both jars to your classpath. Try the below code to create a database automatically:
[This reply is migrated from our old forums. The original author name has been removed]

Re: Creating a connection to a MS Access (accdb) file
The file type MDB has been created by MS Access 97 (Office 8) till MS Access 2003 (Office 11). It can be handled with the database engine ?Jet 4.0?. MS Access 2007 (Office 12) uses the file type ACCDB. It uses a modified Jet database engine, called ?Access Database Engine? (ACE).
[This reply is migrated from our old forums.]

Re: Creating a connection to a MS Access (accdb) file
Another alternative for MS Access now that the JDBC/ODBC Bridge driver is gone is the UCanAccess driver, described here: http://confluence.dbvis.com/display/UG92/JDBC-ODBC+Bridge+Driver+Alternatives Best Regards, Hans