I have been thinking on how to provide the best way to have my software be automatically upgraded on the client PC. I don't know if this is the best way but hopefully you will let me know.

I will have the setup.exe file on my server which would install only the executable to copy over the existing executable. I would have a text file in the same location on my server with the Version Number to check if it is version is out dated. The text file will also contain other important information for my program to execute. I will likely have SQL Query files to possible execute if their are changes I need to make to the local database.

My Main Application will check a hard coded FTP location to see if their version is less than the one I read from a line in that text file. If it is Get the file using iNet control and close my application when the files have finished closing but on close have a Shell call to run my setup file which runs once my Main program has finished closing.

When my clients restart up my program it will run the queries if any and carry on with the updated version....

Sorry for being wordy...