Copy and rename an existing Progress Tracker
database. For example, you can copy and rename the database "sportsSampleModules.mdb" that delivers
with Progress Tracker.
Use the Progress
Tracker Administrator to add the database to the Progress Tracker system. If the database has a user
name or password, be sure to enter it through the Administrator Edit Database Password dialog (shown below).
|
|
When you're adding a database that already has a username and/or password, enter those values in the Administrator's Edit Database Password dialog, select the "Encrypt Password Without Changing Database" button, then click OK.
This will encrypt and write those values to the tracker3.ini file, but will not affect your database in any way.
For example, if you're using a copy of the sample database "sportsSampleModules.mdb" that delivers with Progress Tracker, you should enter "admin" as the user name and "tbk" as the password.
After you have added a database, you can use this dialog at any time to change the database user name or password.
|
Notes on changing the user name or password of your database:
To change the user name and password of your database, you'll typically need to use Access or SQL Server as appropriate to assign a user name and password. Alternatively, if you just need to change the password of an Access database, you can use the above dialog: enter the new password and uncheck the "Encrypt Password Without Changing Database" box. However the Administrator and Reporter cannot change SQL Server passwords, so this box is disabled (in the checked state) when your provider option is SQL.
If you want to change the user name and/or password, enter a new user name and password. Progress Tracker will change the password as described above (unless you check the "Encrypt Password Without Changing Database" box for JET/Access), but will only encrypt the user name and password. You must change the user name manually in Access (Tools menu => Security => User and Group Accounts). You must change both the username and password manually in SQL Server.
See the Progress Tracker Administrator Help for additional details on adding a database and editing passwords.
After creating and defining your database, you must assign it to your front end book or module book. To do this, use the "Assign Database" option from the Tracker menu in your front end book; see Assigning a Database.
 |