I am using click-once deployment but have a new access file but need the old one.

Question

This is the situation. I have a windows form app that uses an access database to store the information. Everything has been going good. Now I am going to release a new version with an updated access file (2 new tables, 1 old table with new column). But the people that have been using the app I don't want them to loose their information when they upgrade to the new version.

How is the best way to handle that situation?

I am using Visual Studio 2008 and vb.net to write the windows form app.

Thanks

Answer 1

The way I see it is you have 2 options

Modify the old DB on each user's computer through code to include the new columns etc

Copy the new DB down on install as a different name then using code again copy over the data from the old one before deleting it and renaming your new one to what it should be called

Here is a link to help with if you go for option 1

http://allenbrowne.com/func-DAO.html