Copy and rename an existing TBK Tracker database.
For example, you can copy and rename the database "sportsSample.mdb" that delivers with TBK
Tracker.
Use the TBK
Tracker Administrator to add the database to the TBK 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 tbksettg3.ini file, but will not affect your database in any way.
For example, if you're using the database "sportsSample.mdb" that delivers with TBK Tracker (or a copy of it), you should enter "admin" as the user name and "test" 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. TBK 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.
After creating and defining your database, you must assign it to your front end book. To do this, use the "Assign Database" option from the TBKTrack menu in your front end book; see Assigning a Database.