About the customers database

The sample task extension includes a small external MS Access database (customers.mdb) to store the customer details for demonstration. The CustomerProperties.bas file defines some constants that can be changed to customize or extend the customers database as shown below. If you change these constants, the task extension must be recompiled.

' Modify these constants to match your customer database
Const DataBasePath As String = "C:\Customers.mdb"
Const ConnectString As String = "Driver={Microsoft Access Driver (*.mdb)};Dbq=" & DataBasePath & ";UID=Admin;PWD="
' The name of the database table containing the customer details
Const CustomerTable As String = "Customers"
' The names of the database fields
Const fldName As String = "Name"
Const fldCustomerID As String = "ID"
Const fldAddress As String = "Address"
Const fldAccountNumber As String = "Account Number"
Const fldCity As String = "City"
Const fldZipcode As String = "ZIP Code"