I have successfully created and published a VB 2005 program with a SQL database. It installs on the user's system fine.

My question is when I update the program, what should I do with the data file? I need to include it in case someone is doing a brand new install with the newer version. But if the original user installs the update, they get the data file overwriting what's currently on their system which obviously is no good.

What is usually done in this situation? I'm using the clickonce deployment so I can't really change anything during the install besides excluding the file.

Greg