You know the scenario where people keep working in an old version of a database, while you work on an update... leaving you
with a new database, but old data?
This concerns a database, containing about 20-25 tables all linked together.
I was asked to make an update. In this update 3 new tables were included and here and there a few of the old tables got news
fields, nothing crucial and a lot of forms were changed.
The current situation:
Database 1: contains new data, misses a few tables, is missing some fields, forms and queries
Database 1.1: contains old data, but some new extra tables, added fields, forms and queries
I would like to know if it is possible to import all data from 'database 1' into 'database 1.1', so that all linked
information between the data is preserved, all database relations are maintained.
If I import tables from Database 1 into database 1.1, tables just get added, not replaced. If I delete or rename tables, I
loose my relationships.
I would like to know what is a common and effective way to get all the new data of an old version of a database (where people
keep working in while you work on an update), into the new version of the database, that currently contains old data.