Q: How do I set up an ODBC connection outside TRAIN TRACK? I am unable to open the Linked Table Manager from inside Microsoft® Access®.

A: To set up an ODBC connection, please follow these steps:

1. From the Windows® Control Panel, select "Administrative Tools > ODBC Data Sources (32-Bit)", or just search for "ODBC". Be sure to select 32-bit and NOT 64-bit.
2. A pop-up window will open. Select the "User DSN" tab.
3. Click "Add".
4. Scroll to the bottom and select "SQL Server Native Client" (or just "SQL Server" if you don't see the native client).
5. Click "Finish".
6. Type in the Name "TTSERV".
7. Type in (or select) the name of your server where the database is installed.
8. Click "Next".
9. Select "Integrated Windows authentication" and click "Next".
10. Check "Change the default database to" and select TRAINTRACK.
11. Click "Next".
12. Click "Finish".
13. Click "Test Data Source".

You should see a message that the test was successful. If not, go back and confirm that you have the correct server name, and that the Windows® user has permission for the database.