JDBC for SQL Server - Herong's Tutorial Examples - v3.14, by Herong Yang
JDBC-ODBC - Creating a MS Access Database File
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.
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 definition with file name like: HY_User.
4. Save the database to file, \local\HY_Access.mdb.
Now my MS Access database file, HY_Access.mdb, with a single table, HY_User, is ready.
Table of Contents
JDBC (Java Database Connectivity) Introduction
Microsoft SQL Server Express Edition
Microsoft JDBC Driver for SQL Server
Microsoft JDBC Driver - Query Statements and Result Sets
Microsoft JDBC Driver - DatabaseMetaData Object
Microsoft JDBC Driver - DDL Statements
Microsoft JDBC Driver - DML Statements
SQL Server - PreparedStatement
SQL Server CLOB (Character Large Object) - TEXT
SQL Server BLOB (Binary Large Object) - BLOB
Using Connection Pool with JDBC
JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver
JDBC-ODBC Bridge Driver - Flat Text Files
►JDBC-ODBC Bridge Driver - MS Access
►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