How do you either (a) transfer a newly revised table structure into an existing database, or (b) transfer existing data into a new table structure?
I have an existing database that has tables filled with data. It is linked to another database which has the queries, forms, reports, macros and modules. I use this database on a daily basis, constantly updating and filling it with new data. I want to make some changes to the tables structures, so I plan to import just the table structures to a new database and make the changes there, so as to not disturb my daily flow of work. There will be added fields, mostly. Some existing fields will have minor changes - like defaults and validation rules (less restrictive, so existing data will still fit in the field). What I can't see is how to then either transfer the newly revised table structure into the existing database, or transfer the existing data into the new table structures.