Q: How do I install a customized update to the Client + Web edition?

A: Please follow the detailed instructions in the Software Installation Instructions document that came with your files. Here is a brief outline of the steps you will need to take:

Back up your database

1. Open SQL Management Studio and find your database in the navigation tree on the left.
2. Right-click on the name of your database and select "Tasks > Backup".
3. In the pop-up window select Backup Type "Full" and Backup Component "Database". Select a secure destination and recognizable file name.
4. Click "OK".

Test your backup - Important! Make sure you have a viable backup!

1. Open SQL Server Management Studio.

2. In the tree at the left, right-clicking on "Databases" and select "New".

3. Type in a database name and click "OK" (For example, "TTTestRestore200804").

3. Right-click on the database and select "Tasks > Restore > Database". A pop-up window will open.

4. In the window, from the "General" page, select the "Device" radio button.

5. Click the elipse (...) button. In the pop-up window, select "Add" to browse to your .bak file (it must be on the local drive). Click "OK"

6. In the "Destination" section, update the database name to the name of the database you are restoring to (double-check this step as it may revert to the original database name).

7. From the "Options" page, check "Overwrite the existing database/REPLACE".

8. Un-check "Tail-Log Backup" if it is checked.

9. Click "OK". You should see a message that the database was restored.

If the file fails to restore, click on the error message for the reason and correct the specified setting. If you need more help, please contact us.

Run the update script

1. Download the installation files and extract them from the .zip file (right-click and select "Extract all").
2. In SQL Management Studio, from the menu bar, select "File > Open > File" and navigate to the script extracted in the previous step (the file name will vary but it will have a .sql extension).
3. Click 'Execute' (the green arrow or red exclamation point depending on your version of SQL).

Update your Desktop/Client interface

1. Make a backup copy of your user interface file and store it in a safe location.
2. From the installation files extracted earlier, locate the user interface file. It should be called "TRAINTRACKxx.accde".
3. Replace your existing user interface with the updated one.
3. Launch TRAIN TRACK. You will most likely see several error messages. Click through them until you are able to open either the Linked Table Manager or the "Link Tables" screen.
4. Enter the information for your DSN-less connection and refresh the linked tables, OR refresh the linked tables using the Linked Table Manager. This step is only required for customized versions. 
5. Enter the updated Registration code (and subscription code if applicable) provided in your registration letter if this is a major update.

Update your Web Application (if applicable)

1. On your web server, navigate to your TRAIN TRACK files located at: C:\inetpub\wwwroot\TRAINTRACK.
2. IMPORTANT: Make a backup of this entire folder and save it to a safe location. Do not skip this step!
3. Locate the new web pages in a zip file in the files you downloaded earlier.
4. Extract the files  (right-click and select "Extract all").
5. Replace your existing pages with the new ones EXCEPT the files in your "Connections" folder.
6. Launch your TRAIN TRACK web application.