Before we can populate the combo box, we need to set up the ODBC connection to the Northwind database.   This is done through the ODBC Data Source Administrator, a program which is either launched from Control Panel or from Administrative Tools, depending on your Windows version.

The display will be similar to the one shown below:

Highlight MS Access Database as the data source, and click Add... to start setting up a User DSN type connection for Microsoft Access.  A dialog similar to the one below displays (without the edit lines being filled in, of course).

Fill in this dialog as follows:

Data Source Name: NWIND

Description: Northwind Database

Database: Click Select... to find the location of your copy of NWIND.MDB.  Once you have found it, select it.

Then click OK. Click OK again to save the ODBC connection definition.

  • No labels