Q: When I try to open the client interface, I get a message that the Open Form action was canceled.

A: This is likely happening for one of two reasons: (1) an ODBC connection has not been set up from the workstation or (2) your Windows login name has not been added to the TRAIN TRACK® SQL database.

Please close TRAIN TRACK® and double check the following steps on the workstation:

1. Open the Control Panel and select "Administrative Tools" (or just search for "ODBC").
2. Click on "ODBC Data Sources (32 bit)".
3. In the "User" DSN tab, click on "Add".
4. In the "Create New Data Source" window, select the "SQL Native Client“. It is usually the one at the bottom. If you don't see this option, select "SQL Server".
5. In the "Create a New Data Source to SQL Server" pop-up, enter the following and click "Next":

Name: TTSERV
Description: (optional, type in a description)
Server: select (or type in) your SQL server

6. In the following window, select "with integrated windows authentication" or "with windows NT authentication" and click "Next".
7. Check the box that says "Change the default database to:" and select "TRAINTRACK". Click "Next".
8. On the following screen, click "Finish".
9. On the following screen, click "Test Data Source" and then "OK".

Note that these steps assume that TRAIN TRACK® was installed according to the defaults and that your database is named TRAINTRACK.

If the test runs successfully, close and re-open TRAIN TRACK® and it should auto-connect to your database. (The security warning can be disabled by changing your settings in MS Access®). 

If you still get an Open Form Action error, please double check that your Windows® login name has been given correct permission for the TRAIN TRACK® database. You can do this by adding the user to the user group that already has access to TRAIN TRACK® , or by adding the individual user through SQL Management Studio. 

1. Open SQL Server Management Studio.
2. Find the Security folder in the navigation pane on left. Right-click and select "New Login".
3. In the pop-up widow, under "General", confirm that "Windows Authentication" is checked and click on the "Search" button.
4. Click on the "Advanced" tab and then "Find Now".
5. Select your TRAIN TRACK® user group or individual user names and click "OK" and "OK" again.
6. From "General", click on "User Mapping". Select the TRAIN TRACK® database and check "datareader" and "datawriter".
7. Click "OK".