JDBC-ODBC - Creating a MS Access Database File

<< JDBC-ODBC Bridge Driver - MS Access

<< JDBC Tutorials - Herong's Tutorial Notes

This section describes how to create a MS Access database file to be used for ODBC MS Access driver testing.

In order to test how to work with MS Access databases through JDBC-ODBC Bridge, I did the following to create a MS Access database file named as HY_Access.mdb:

1. Run MS Access, select the "Blank Access database" option, and enter the file name: HY_Access.mdb.

2. Select "Tables" in the Objects list, then double-click on "Create table in Design view".

3. Define the following columns:

ID           AutoNumber
FirstName    Text
LastName     Text
Point        Number
BirthDate    Date/Time

Save the table denition with file name like: HY_User.

4. Exit MS Access. Now my MS Access database file, HY_Access.mdb, with a single table, HY_User, is ready.

Sections in This Chapter

JDBC-ODBC - Creating a MS Access Database File

JDBC-ODBC - Creating DSN for MS Access

JDBC-ODBC - Connecting to MS Access Database Files

JDBC-ODBC - MS Access Database and Driver Info

JDBC-ODBC - Creating New Tables in MS Access Database

JDBC-ODBC - Inserting Data Rows to MS Access Database

JDBC-ODBC - Running Queries on MS Access Database

Creating Connections with DataSource Class