Move the database and set up data sources

1. Copy your Standard Time database from your local machine to a file to a file server.  Your database file is usually found in C:\Program Files\Standard Time.
   
   NOTE: These steps below must be performed on each client workstation that will be connected to the shared database.  (Approximate time: 60 seconds).
   
   
2. Open Standard Time and choose Tools, Options, Database.
   
   
3. Click the ODBC Administrator button to open the Administrator dialog shown below.
   
   
   
   
   
4. Click the File DSN Tab.  You will see a data source named "Standard Time mdb.dsn".  This data source is currently used to connect to your local database file.
   
   
5. Click the "Standard Time mdb.dsn" data source to select it.
   
   
6. Click the Configure button to modify the data source.  This dialog will be shown.  (Alternatively you can create a new data source using the "Add" button.  This allows you to name them differently and remember that you are connected to a shared database rather than the database on your local machine).
   
   
   
   
7. Notice that the database shown [above] is located on your local hard drive.
   
   
8. Click the Select button to choose a new database file.  This dialog will be shown.
   
   
   
   
9. Navigate to the file server that contains your database.  (This is the database that you copied from your local hard drive to the file server earlier in this article).
   
   
10. Choose the database file and click OK.  Notice that your data source now points to the database on the file server, as shown in the example below.
    
    
    
    
11. Click OK to close all dialogs.
    
    
12. From within Standard Time, choose File Exit to restart Standard Time.  (You must choose File Exit to stop Standard Time.  The close button only closes the main window, but leaves the program running).
    
    
13. Restart Standard Time.  You are now connected to the shared database on the file server.
    
    
14. You may consider renaming the database file on your local machine so that there is no chance of confusion as to which database you are actually connected to.  Use the Windows Explorer to go to C:|Program Files\Standard Time and rename "Standard Time.mdb" to "Standard Time_OLD.mdb".  This will ensure that you do not inadvertently connect to this database.