>I've got an existing app and (dread) users with live data. I want to use the Needupdate and Update methods to check their databases against changes I've made for them (eg, "Can the address number field be bigger")
>
>So far I tried:
>1) put a version of the code sample "Update only those tables that are out of sync and don't exist" in the config.fpw file.
>2) make an exe called ehupdate.exe and told the Setup Wizard to run it as an executable at the end.
>3) put the code snippet in the "Utilities" where I have snippets (yours) that Reindex and Repair databases.
>
>Are either of these the best way? Thanks for the great tools.
>
>Sylvia

Sylvia,

The best method I have found is to use the version number of the app, you can write this to the users registry. Then when you are ready to distribute a new executable, change the version number in VFP before you build. The user then installs the new executable. Each time they start, you compare the version number of the executable against the registry, if they are different, run needupdate.

Kind Regards,

Mat