HOME PAGE

Introduction
  How It Works
  Assumptions

Getting started

First Time Use
  Setup

Tutorial

Changing Data
  Data Structure
  Data
  Relationship
  Index
  Comments

Distributing Your New Front End

Data PRO Links

SSW Data PRO!SSW Data PRO!

Distributing your new Front End

When 'SSW Data PRO!' is used to make changes in the backend database, all the changes are logged. Every time you make a structural change to the database, 'SSW Data PRO!' records this in the table 'zsDPDataChange'. Once you process the change, 'SSW Data PRO!' will then make the change to the back end. At the same time a log record is created in the backend table '_zsDataVersion'

When the front end is distributed, it checks whether the backend is old and needs upgrading. If old, the front end will automatically make all the necessary changes in the back end.

Note: You do not need to install 'SSW Data PRO!' on clients machine. Just include 'DataPRO97.mde' or 'DataPRO2000.mde' in the same directory as the application.

 

Upgrading the Backend

To upgrade the backend please follow the following steps:

Note: These steps will only apply if your 'SSW Data PRO!' version is 13.4 or greater. For 'SSW Data PRO!' version less then 13.4 go to 'How to upgrade to 'SSW Data PRO!' version 13.4 or greater?' at bottom of this page.

    Run your front end application and run macro 'SSWSampleAutoExec_v1'. You will see the following screen:

    Upgrading the Backend

    Click 'Yes'. Then you will be prompted for the location of 'SSW Data PRO!'. You will see the following screen:

    Upgrading the backend

    Select 'SSW Data PRO!' (for example 'DataPRO97.mde') file and click open. A message box will appear informing you about starting of upgrade. Once you click 'Ok' you will see the following screen.

    Upgrading the Backend

    Click 'Next>' to proceed with the upgrading.


How to upgrade to 'SSW Data PRO!' version 13.4 or greater?

For users using 'SSW Data PRO!' reference in the front end application

    Remove the 'SSW Data PRO!' reference from your from end application.

    Delete the function 'bolSSWDataPROUpgrade()' from macro 'Autoexec'.

    Import the following from the 'SSW Data PRO!' version 13.4 or greater installation:

      Modules 'basSSW1_OpenDialog_aGetFileName_v6' and 'basSSWDataPROUpgradeNoReference_v1' and macro 'SSWSampleAutoExec_v1' from file 'SSWDataPROUtilities(97/2000).mdb'

      Note:
      For Microsoft Access 2000 choose 'SSWDataPROUtilities2000.mdb' and for Microsoft Access 97 choose 'SSWDataPROUtilities97.mdb'.

    Now you can simply follow the steps described above in 'Upgrading the backend'.

For users using 'SSW Data PRO!' without reference in the front end application

    Delete the following form your front end application

      basSSW1_OpenDialog_aGetFileName_v6 (Module)

      basSSWDataPROUpgradeNoReference_v1 (Module)

      SSWSampleAutoExec_v1 (Macro)

    Import the following from the 'SSW Data PRO!' version 13.4 or greater installation:

      Modules 'basSSW1_OpenDialog_aGetFileName_v6' and 'basSSWDataPROUpgradeNoReference_v1' and macro 'SSWSampleAutoExec_v1' from file 'SSWDataPROUtilities(97/2000).mdb'

      Note:
      For Microsoft Access 2000 choose 'SSWDataPROUtilities2000.mdb' and for Microsoft Access 97 choose 'SSWDataPROUtilities97.mdb'.

    Now you can simply follow the steps described above in 'Upgrading the backend'.

To see it in action

    Rename your current backend to 'zzNorthwindDATA.mdb'

    Rename the backup (you created at start of this tutorial) 'NorthwindDATABackup.mdb' to 'NorthwindDATA.mdb'.

    Open your front end application that will start the upgrading process.

Now you can issue the new front end database version that you have just completed to your clients. The above upgrading process will give you peace of mind because you know that your database will check the clients current data version (in '_zsVersion Data') and compare it with the current version required (in 'zsDPDataVersion') before performing any necessary upgrades.

However, before distributing your database make certain it has been put through the First Time Use process. This is because the data.mdb you release must have the system table '_zsDataVersion' in it, as the next time you send your application (that will include 'SSW Data PRO!') it will look for this table so it can determine what version it is.

Enhancement for version less then 14.9.

You have to delete the old version of basSSWDataPROUpgradeNoReference_v1 in client front end application, for example in NortwindApplication and add a new version of the module basSSWDataPROUpgradeNoReference_v2 there. You copy the module basSSWDataPROUpgradeNoReference_v2 from SSWUtilities97/SSWUtilities2000.mdb. Compile and save all modules.

We hope you enjoy using 'SSW Data PRO!'.

The 'SSW Data PRO!' Team.

Goto previous page

SSW