Access Vs. DB2 Table Definition Form

 

When blank, the Matching DB2 Column combo-box lists the columns in the DB2 table with no Access counterparts. In this example, we renamed the ID field to ID_NO. Since we wish to keep existing data, the ID column is selected as the DB2 column associated with the Access ID_NO field.
 

DB2 Name to Use	The name of Access field to be associated with the DB2 column
Matching DB2 Column	The name of the DB2 column to associate with corresponding Access field (DB2 Name to Use.)

 
Data Type Changes
For the sake of example, we will change the PHONENO field from Text to Integer. Since this type of alteration is not supported using ALTER TABLE, a table rebuild is required. See the Troubleshooting section to avoid numeric overflows and invalid date errors.