Opening the ODBC tables

Example: MS Access

The IGSS ODBC interface can be used with any SQL-enabled database. We have chosen MS Access for the examples in this Help file, because it is the most widely used database among our customers.

To learn about the procedure used in other database products, refer to the system’s documentation.

STEP 1: Create a new database

Important: Before you open the ODBC tables, make sure that you have selected the appropriate active configuration in System Configuration. Note that you cannot create a new configuration from the ODBC interface, this must be done from Definition.

In order to access the ODBC tables, you must create a new database and name it.

  1. Open MS Access and create a new database by double-clicking the Blank Database icon. The File New Database dialog box appears.
  2. Name the database and click Create.

Tip:  You may want to save the database in the configuration root folder, for example, as ODBC.mdb.

STEP 2: Link the ODBC tables to the database

The next step is to link the ODBC data source to the database as follows.

  1. Right-click the database window and select Link Tables.

images\men_link.gif

  1. In the Files of type box, select ODBC Databases ().

images\sel_odbc.gif

  1.   On the Machine Data Source tab, select the  IGSS32v8 ODBC Network DS data source and click OK.

images\data_src.gif

STEP 3: Select the tables you want to edit

  1. On the Tables tab, select the specific tables you want to view or edit and click OK.

Click Select All to show all the ODBC tables.

images\link_table.gif

STEP 4: Edit the tables

The tables are now ready for editing. For further details about editing, click here.