Preserving relationships based on Autonumber keys

[MikeB]

Oh Boy.

I redesigned my little system, define brand new tables and lovely
forms based on these tables.

Then it came time to get my data from the old tables into the new
tables. Simple, right? All I need are make table or append table
queries to populate my new tables based on the old tables, right?

No, I forgot that the tables and relationships are based on autonumber
keys and that the keys would not necessarily be the same in the new
tables as they were in the old tables.

Does anyone have any advice on how to migrate a bunch of tables into
new tables while preserving relationships based on autonumber fields
in the old tables?

 

[Albert D. Kallal]

If the tales are empty, then you *can* import the other tables...autonumbers
and all....

Just do a compact and repair after words, and the autonumber system should
continue to function...

 

[MikeB]

If the tales are empty, then you *can* import the other tables...autonumbers
and all....

Just do a compact and repair after words, and the autonumber system should
continue to function...

Oops. You're right. There must be some other problem with what I'm
trying to do then. Back to the drawing board...

 

[Tom Wickerath]

Hi Mike,

If you already have relationships with enforced referential integrity, then
you will need to add records to the parent tables first, before attempting to
add records to the related child tables.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________