So I have an MS Access 2010 Application being used. Over the past few months we have created a new one based on the customers feedback. It still has the same look and feel as the old one, we just added and renamed fields as requested and made a bunch more reports.
So taking the data from the current application and coping it into the new is not going to be an option. Things just wouldn't line up if we did that.
What is the best way to insert new fields into the existing tables?
What is the best way to rename existing fields?
This is what I imagine happening. If this is new application to be installed then there is no need for an upgrade and the application can be used as is. But if they have version 2.0 and want to upgrade to 3.0 without losing any information then during the install they will be asked if new installation or upgrade. When the click upgrade a window pops up and asks for the path to the backend of the current 2.0 application. Once selected it will ask them if they are sure they want to upgrade and then ask if they would like a back up made of their backend. If they hit yes a backup is made and then it asks them if they want to continue to upgrade. When they hit yes a window pops up saying the following:
Now upgrading [Table Name]
and it cycle through the tables being updated.
Then it changes to
Now inserting new queries and so on with forms and reports.
I can ask all these questions separately which is what I will end up doing.
But the my main questions I have is how do I get the new application to insert fields into the old tables, How do I insert new tables into the old application and how do I rename tables and fields in the old one.
I know it can be done and I remember doing this back in Access 2.0 but I can not remember for the life of me how. I do remember I had to create the table and then each field separately. All via code.