Tadds - The ADministrator's Database System ®

  Tip 3:  Converting a BackEnd system from Access/97 to Access/200x when you
             no longer have any FrontEnds using Access/97.
                                                 
(updated 08/08/04)
 

  Note:  In all the following steps, you should be logged onto the Windows system under the UserID
             that will be used to run Tadds on that machine.

  1.  Before you start the conversion:

     A.  Create a Tadds data export diskette containing your current data.    Label this diskette as
          "Tadds Export, Pre-2K Upgrade".  This is so you can reload your student data into the new
           version of the Tadds BackEnd database.

          Note:  If your site is using the  Injury Tracking  feature, be sure to create the above data export
          diskette at a FrontEnd machine that has access to the medical injury-tracking database.
 

  2.  On the BackEnd machine

     A.  Create a TempSave directory some where on your hard drive and copy the contents of your BE
          directory (including subdirectories) to it.  (This is for recovery if something goes wrong.)

     B.  Delete the contents (including any sub-directories) of your BE directory.  NOTE:  Do NOT
          delete the BE directory itself.
 

  3.  TIP:  If installing to a "root" directory:

     If you want to install any flavor of  Tadds to a drive's "root" directory (such as H:\ or T:\), you
     must specify the root directory with a trailing period.  Example:       H:\.
 

  4.  At a FrontEnd machine that is using A200x:

    A.  If the machine also happens to be the one containing the BE directory:

          1.  Do a Tadds BackEnd install.
               a.  Specify NEW BE database
               b.  Specify LOCAL location.
               c.  Specify the actual location of the BE directory. Default is C:\Program Files\Tadds_BE.
          2.  Do a Tadds FrontEnd install.
          3.  Start the just-installed FE application, supplying the password for the medical database.
          4.  Use the Tadds data IMPORT utility and the data diskette that was created in step 1, above,
               to restore your data to the new backend database.
          5.  Skip to step 5.A

     B.  If the machine is not the one containing the BE directory:

          1.  Make sure that the machine is linked in R/W mode to the (now empty) BE directory that is
               that is located on the BE machine.  (We recommend linking it as shared-drive ID of T: but
               you can specify other drive ID's if you need to.)

          2.  Do a Tadds BackEnd install.
               a.  Specify NEW BE database
               b.  Specify REMOTE location, using A2000 or higher.
               c.  Specify the BE-directory's linked drive ID (or ID\FolderName).
          3.  Do a Tadds FrontEnd install.
          4.  Start the just-installed FE application, supplying the password for the medical database.
          5.  Use the Tadds data IMPORT utility and the data diskette that was created in step 1, above,
               to restore your data to the new backend database.
          6.  Proceed to step 5.A
 

   5.  At each FrontEnd machine that is using A200x:

     A.  If the FE's Tadds version is less than 31216:  Do a Tadds FrontEnd install at this machine.

     B.  If the FE's Tadds version is 31216 or higher:  You do not have to do anything to this machine.
          It will self-update the next time the user starts the FE application.

     NOTE:  In both cases, the newly-updated FE applications will ask for the password of the medical
     database when they are first started after an upgrade.  You can supply it or not, your choice.
 

   6.  That's it.  You are done.

     A.  But you might want to consider creating another (using a different diskette) Tadds data EXPORT
           diskette of your data, since you have now updated it to the new level of Tadds.  Label this
           diskette as "Tadds Export, Post-2K Upgrade"
 

   7.  What if it is all messed up and I want to undo the changes?

     A.  Remember the TempSave directory you created in step 2.A, above?  Just copy its contents to
           the BE directory on the BE machine (specifying "replace all").

     B.  Then go to every FE machine that has been updated via steps 4 or 5, above, and (using the
           old-level version of the Tadds install CD or setup.exe file), do FE installs.

     C.  That's it.  You have returned to the original version of Tadds and student data.