Q: I have a client machine that is using Access Runtime and does not have Linked Table Manager. We did not use the default database name or DSN, and it doesn't connect. What can I do?

A: If you have another workstation where the client is already connected, you can copy the user interface file from that machine to this one. Just locate the "TRAINTRACKxx.mde" or "TRAINTRACKxx.accde" file and replace the one on this machine with the one that is already connected.

If TRAIN TRACK is not yet installed on any other workstations or you are unable to copy that file, you will need to set up the ODBC connection on this computer using the below steps:

Create the ODBC connection on the new workstation

1. Open the Windows® Control Panel and select "Administrative Tools > ODBC Data Sources (32-bit)". Be sure to select 32-bit and NOT 64-bit.
2. Select the "USER DSN" tab and click "Add".
3. In the "Create New Data Source" window, select the SQL Native Client (it is usually the one at the bottom). If you don't have the Native Client, select the SQL driver.
4. The "Create a New Data Source to SQL Server" window will open. Enter the following and click "Next".

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

5. Select "with integrated Windows® authentication" or "with Windows® NT authentication" and click "Next".
6. Check the box that says "Change the default database to:" and select "TRAINTRACK". Click "Next".
7. Click "Finish".
8. Click "Test Data Source". You should see a message that the test was successful. Click "OK".

Tags: ODBC, Linked Table Manager, database connection, installation, new user.