A
AK
Hello All,
I am really all turned around. New enough to not know better!!!!
Problem Setup:
I have made some changes to my VB application so it captures more data and
writes it th a database. In the writing of my Version 2 of my app, I took
my existing db and just added the necessary additional tables, and added a
few fields to some of the pre-existing tables, and created new relations for
those the new tables back to the old tables. (may have changes some of the
relations between the old tables too. But just in a few places.
Some of my records are autonumbered.
Problem Statement:
I want to get the old data into the new database, yet find that it is not as
simple as a cut and paste or an import. I thought for example that on those
tables that have had no change in structure, that I could just copy the info
out of the earlier database and plop it into the corresponding new database
table. Problem is with the auto numbering. The new db renumbers them, and
of course this screws up the relations the records in one table are supposed
to have with other tables.
Here is what I propose doing to map my database. Is this the way it is done,
or is there an easier way? Or will this crater too???
Open up the relations view of my new database.
Do a file import of all the tables and data from the old database into the
new database. (Thank goodness Access will auto remane tables which would
have duplicate names otherwise).
I then propose to arrange the imported tables to match the layout of the
ealrier tables.
I would then add new tables as needed to match so that at the end of the
"mirroring" my tables would be the same.
I propose to then mirror the links on the imported/added tables, then delet
all the old tables, the rename the the new tables to their old name was.
(Table ProjectNumbers1 becomes ProjectNumbers (the name of the corresponding
table in the old database.)
I propose that this will create a mapping by proxy of the old data to the
new database structure.
I am really all turned around. New enough to not know better!!!!
Problem Setup:
I have made some changes to my VB application so it captures more data and
writes it th a database. In the writing of my Version 2 of my app, I took
my existing db and just added the necessary additional tables, and added a
few fields to some of the pre-existing tables, and created new relations for
those the new tables back to the old tables. (may have changes some of the
relations between the old tables too. But just in a few places.
Some of my records are autonumbered.
Problem Statement:
I want to get the old data into the new database, yet find that it is not as
simple as a cut and paste or an import. I thought for example that on those
tables that have had no change in structure, that I could just copy the info
out of the earlier database and plop it into the corresponding new database
table. Problem is with the auto numbering. The new db renumbers them, and
of course this screws up the relations the records in one table are supposed
to have with other tables.
Here is what I propose doing to map my database. Is this the way it is done,
or is there an easier way? Or will this crater too???
Open up the relations view of my new database.
Do a file import of all the tables and data from the old database into the
new database. (Thank goodness Access will auto remane tables which would
have duplicate names otherwise).
I then propose to arrange the imported tables to match the layout of the
ealrier tables.
I would then add new tables as needed to match so that at the end of the
"mirroring" my tables would be the same.
I propose to then mirror the links on the imported/added tables, then delet
all the old tables, the rename the the new tables to their old name was.
(Table ProjectNumbers1 becomes ProjectNumbers (the name of the corresponding
table in the old database.)
I propose that this will create a mapping by proxy of the old data to the
new database structure.