Easysoft JDBC-Access Gateway User's Guide - Introduction

Introducing the Easysoft JDBC-Access Gateway

The Easysoft JDBC-Access Gateway is a type 2 JDBC driver for Microsoft Access databases.

Chapter Guide

Overview

The Easysoft JDBC-Access Gateway provides JDBC access from Java applications, application servers and servlets to MDB or ACCDB files. If you configure your Java security policy to allow the Easysoft JDBC-Access Gateway to load its native component, the driver can also be used with Java applets.

Product Status

The Easysoft JDBC-Access Gateway is currently available on Windows platforms. The most up to date list of Easysoft JDBC-Access Gateway platforms is available at:

http://www.easysoft.com/products/data_access/jdbc-access-gateway/index.html

Software problems can be reported to support@easysoft.com by users who have either purchased support or registered at the Easysoft web site at http://www.easysoft.comand are evaluating Easysoft products.

Deployment

Access has four components: a structure to hold data (tables), a way to manipulate that data, an environment to create a front end for the data (Design view of forms and reports) and tools that can run the front end (Data view of forms and reports). Access data is stored in a database file, which has the extension .mdb or .accdb.

The Easysoft JDBC-Access Gateway is a JDBC driver for Access that uses the Java Native Interface (JNI) to communicate with Microsoft's Access ODBC driver library. The Access ODBC driver is used to connect to the target database file.

The Access ODBC driver must be installed on the machine on which you install the Easysoft JDBC-Access Gateway. Since Windows 2000, the Access ODBC driver (one of the Jet Database Engine Components) has shipped with Windows and so should be already present on your machine as part of the Windows installation.

If the file you want to connect to is an ACCDB format database (.accdb) you need to install aceodbc.dll on the Easysoft JDBC-Access Gateway machine.

The version of aceodbc.dll that is intended for use with Office 2010 files is available to download from:

http://www.microsoft.com/en-gb/download/details.aspx?id=13255

The version of aceodbc.dll that is intended for use with Office 2013 files is available to download from:

http://www.microsoft.com/en-us/download/details.aspx?id=39358

The target database file must be visible through the local file system on the Easysoft JDBC-Access Gateway machine. For example, in a folder on this machine or a mapped network drive or in a shared folder.