Microsoft Access tables are generally imported into CONNX through use of the default user name "Admin." Security levels remain at default levels during import.

When starting the import procedure for OLE DB/ODBC Providers using Microsoft Jet Engine 3.51 or 4.0, users should start the application using an appropriate DSN and log into CONNX. If it is the first time the user has opened the CDD, a CONNX dialog box appears with the following message:

"The user does not exist in the CONNX data dictionary. Would you like to create an integrated CONNX account for this user name?"

If this dialog box appears, the system fails in connecting to the Access database file, and the CONNX Database Login dialog box appears.

This error occurs because CONNX is attempting to use the CONNX user name and password for the Access database login. Since the Access database is expecting the user name "Admin" and no password to be entered, this initial attempt at logging on fails.

To correct this situation, change the displayed user name to Admin and leave the password blank. Do not change the server field.

To add a CONNX user manually through the CONNX administrator, you must enter the OLE DB provider name in the Server Name field, for example:

Microsoft.jet.oledb.4.0