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!!