VB6/Access Upgrade

[flamesfan]

I have a fat-client application written in VB6 with an Access database that is currently installed on several different machines. I have made upgrades to this application that involve the Access database (added columns, removed columns, change column data types, etc). I need to retain the data that already exists in the database on these machines and want this data to be ported to the new database when it is installed.
What is the easiest way of doing this?
Thanks in advance!!

[randem]

The easiest way is to include a new database with all the added fields and new queries to transfer the data from the old database. So you can write a small app that does nothing but executes the queries to transfer the data.

[BodwadUK]

Thats is probably the only way

[Hack]

Make sure, however, that you either:

1. Name the new database a different name than the old database so the old database doesn't get overlayed.

2. Or, if you wish to retain the same name, place the new database in a different folder than the old database so the old database doesn't get overlayed.