Primary Keys: Importing Access DB in Access DB

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

Hello!

I hope somebody can help me:
I have an Access DB and want to give a copy to another
person. The other person and me will work parallel on our
copies of the DB. After a while we want to merge the two
DBs to one big DB.
I have the problem that it can happen that two different
records have the same primary key... (AutoNumbering by
Access)
How can I append the records of one table to another and
change - if necessary - the primary key 'on the fly'?

Thanks for your help!

Frank
 
Frank,

You can join or inport the table in the other copy into your own, and use an
append query to apppend data from one table into another; you will just
append every other field but the PK. The PK being an autonumber field in the
destination table, the appended records will be automatically assigned new
PK values (not the same they had in the source table).

HTH,
Nikos
 
Back
Top