Set up ODBC without using Linked Table Manager

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:

Object not found

Q: I am installing the TRAIN TRACK interface on an additional workstation but can't connect to the database. I  keep getting "Object not Fou

Seeing different data

Q: When one user opens TRAIN TRACK, they do not see the same data as another user. A: The users might not both be opening the same database. To verify, enter a test record from one workstation and make sure yo...

ODBC connection failed SQL state 08001

Q: After successfully creating the TRAINTRACK database in SQL and double checking that all installation steps in the documentation were completed, the client computer is still unable to connect to the Server. W...

Can't find dbo.FilterTrainingDeleted

Q: When I open the client, I get a message that it can't find the table "dbo.FilterTrainingDeleted". A: This may be caused by the interface not being the same version as the database. Check to see if that view ...

Can't connect to server - untrusted source

Q: I set up my ODBC to use SQL authentication, but when I open TRAIN TRACK I get an error that the login is from an untrusted source. A: Click cancel, and a SQL login box should open. Un-check "trusted locatio...

Architecture mismatch

Q: When trying to connect the client to the server, there is an error message with "Architecture mismatch". A: An error message with "Architecture mismatch" means the 64 bit ODBC tool was used instead of the ...

"#Name?" appears on screen

Q: After updating my program, I am seeing #Name? on one of my screens.A: Run the linked table manager to re-link your data tables after updating to a new version. Click on the Database Administration tab and...

Open Form Action was Canceled

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 works...

Open Form Action Canceled

Q: I am trying to install TRAIN TRACK. When I launch the program, I get an "Open Form Action was canceled" error. If I click OK and then click "Linked Table Manager," nothing happens. Even though I am using th...

Can't see employee or training records

Q: I know there are employee and training records in the database, but I can't see them through the user interface. If I try to add a new one, it just shows #deleted# in all of the fields. I am logging in to t...

ODBC runs successfully but Client does not connect - connection failed error

Q: I have gone through the ODBC connection steps and the test ran successfully but when I open the Client interface, I get a connection to TTxxxxxx failed to connect error. A: When setting up ODBC, please make...

SSL Security Error

The expression On Open... produced the following error: ODBC connection to (DSN) failed

Q: I have successfully set up my ODBC connection, but when I open the Client interface, I get the error "The expression On Open you entered as the event property setting produced the following error: ODBC conne...