Connecting to a Password Protected Database

Description

How can I prevent Loftware from prompting for a password each time I open a label connected to a password-protected database?

Solution

If you would like to allow access to labels which are connected to password protected databases, but do not wish to give out the database password, follow these steps to allow automatic access to such labels and databases:

1. From the Design program, open the label(s) in question and select the database-key field.
2. Click Advanced, and enter a valid user name and password for the database in the following format:

UID=<username>;PWD=<password>;DSN=<DSNName>;
For example
UID=Administrator;PWD=55555;DSN=TEST;

*Please remember that the entries for UID, PWD, and DSN are all case sensitive