JDBC Access Tutorial
Tutorial on preparing JDBC with Access
Open MS Access Application to make a database.
Create a new blank database.
Name the database file.
Open the tables section to define a new table (like create table).
Select “Design View”
Give names (labels) and data types to fields (columns).
Close the table definition and save.
Name the table that you have just defined. This name will now appear in the list of all tables in this file. Double Click to open table.
Type in data and exit Access.
Register your database with ODBC.
Select MS Access Driver.
Select the name of your database file.
Create an ODBC name for your database file and Click o.k.
Example Java Program (Java Application)
Go to the Command Prompt window. Compile java and run the application.
Email: gcf@npac.syr.edu
Home Page: http://www.npac.syr.edu