The connection string to open the database can be entered directly into the field. For help on constructing the connection string use the browse button to open the Data Link Properties form.
Select the OLE DB Provider of the data that is to be connected to. Click Next to move to the Connection Tab.
Specific information relating the Database provider needs to be completed. Help of the information required for each of the fields can be obtained by clicking the Help button. Fields available will be dependant on the type of provider. Test that the information entered will allow entry into the database, click the Test Connection button. A message Test Connection Succeeded will show if successfully connected to the database.
Network Settings & other settings e.g. Access permissions. Fields showing will be dependant on the type of provider selected. Click help for specific information about any of the fields.
The properties that have been selected on the previous tabs are shown in the All Tab. Amendments can be made as required by selecting the Name and click Edit Value.