Updating the tables from old database to new

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All of the discussions about merging or appending data in tables fail to
mention the primary key and other related tables. I am trying to write a
routine to update a client's backend file to the latest revision and I am
runnining into the problem of making sure that the old primary keys are
maintained so that the relations to subordinate tables don't get mixed up.

I tried to copy/append the record fields/values from one table to another
but it can't copy/update the primary key field. If you let Access create a
new primary key, how do you match it up with the other related tables that
reference the old key?

How does everyone else do this?

Beth
 
Never mind. I decided that I was using the wrong approach. I have since
written a routine to update the table defs in the Client BE instead of moving
data.
This will be safer and quicker. This also can be used on any BE, ie not
specific to one database. I can use this for all of my products.
Thanks anyway,
Beth
 
Back
Top