Updating ADP front from SERVER

[Farzam]

Dear all,

I have a SQL SERVER with ADP Front.
I put a copy of the ADP front for all my clients
the original copy is in the server
by time passes i usually update the front END ADP in the server.
now my question is when ever client runs the front ADP it must check the current open ADP with the client and the original in the server , if the file names are not the same then it should run a batch, which i already have to update the new updated copy from server to client DRIVE C:

fore time being i can do it when client clicks on a button in their ADP copy.
but sometimes client dont remember to update regularly

regards,

 

[jrbarnett]

Use a batch shortcut to run the front end application.
This can compare the database to the one on the server, copy the new database if there is a new one and then run the application.

In the application, put a version number and another in the database. Compare the two and display a warning at startup along the lines of "Version mismatch, please contact XYZ" which is likely to get around anybody accessing the application directly rather than through the batch.

You have to remember to increment the number with each release on both the database and the frontend.

John