>>What if application change also involves adding/changing some tables (and their structure)?
>>
>
>What we used to do (where I previously worked) was, at the beginning of the code, have it check for something in the database that would be new since the last update. If it is not there, then run some extra code (like in a db_fix.prg), that would go in and update the database to the new level you need.
>
>Next time it runs, it would ignore this, and skip it.
>
>But you have to keep db_fix updated with any new changes to the database (must be in sync or all $#!!#!#$#$ breaks loose!!
>

Mmmmmmmmmm on more reflection, I remember we had to get them out for the update to work.... so this would not work with the automatic downloading of the new exe.

sorry...

Tommy