This talk consists of a set of screen dumps that illustrate the process of setting up an example using JDBC with Microsoft Access on a PC. The JDBC driver is the JDBC-ODBC bridge.
|
001 JDBC Access Tutorial 002 Tutorial on preparing JDBC with Access 003 Open MS Access Application to make a database. 004 Create a new blank database. 005 Name the database file. 006 Open the tables section to define a new table (like create table). 007 Select "Design View" 008 Give names (labels) and data types to fields (columns). 009 Close the table definition and save. 010 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. 011 Type in data and exit Access. 012 Register your database with ODBC. 013 Select MS Access Driver. 014 Select the name of your database file. 015 Create an ODBC name for your database file and Click o.k. 016 Example Java Program (Java Application) 017 Go to the Command Prompt window. Compile java and run the application.