Upgrading a customer ? (1 Viewer)

[Davef28]

We have several customers using a system. We have made several changes to tables to improve the functionallity of the system. I am looking for suggestions for the best way / best practice to implement these changes throughout our customer base. I am thinking along the lines of sending a blank database with new tables and somehow getting the data alone imported.

Many Thanks in advance

Dave

 

[charityg]

I ran into the same issue years ago when using access as the backend database to a visual basic application our company developed and distributed. If I'm understanding your situation, you have tables that allow customers to save their specific information and you want to modify those tables without purging the information. There are some specific VBA commands that will allow you to add fields to your tables. If this is what you are looking to do, look in help under the ALTER TABLE method.