Connect to a Live and a Test Database
Q: How can I connect my user interface to both the test database and the live database?
A: To allow a user to connect to two separate back-end databases, you need to set up two separate ODBC connections and then switch them each time you use TRAIN TRACK® by opening the Linked Table Manager and selecting a different connection.
As an alternative, you may install two copies of the interface, connect one to each back-end, and label them so you know which is which.
We also recommend adding some "flag" data in each database to confirm which one you are in when you open it (for example, a training record called "_Test_Database" or something like that).