copy table with records from one DB to other DB

[klimmer]

Hi,

I have 2 DB's with the same structure of tables.
In one DB the records are more up to data.

When I would like to update the my information, I have to copy 2 table
from one to the other DB.
The ID's are very important that the stay the same number.

I have tried to delete the tables in my destination DB, but I get the
message that I gone destroy the relationships between other tables.

When I delete the records and the copy the records my ID's increment.

Can I reset the counter of the ID's?
Does somebody has a solution?

 

[Wayne-I-M]

Hi

I'm not sure what you are looking for. Can you append (add records) to your
table - this means the relationships will stay in place.

It's quite simple to add records from one database to another - of course
this means that if you use autonumbers for ID fields they may be wrong on the
appended records. You could also just copy the table but I don't think this
is what you need in this case

So - Can you take records from one DB and add them to the other - if so let
me know and I will post the code for you.

 

[John W. Vinson]

Hi,

I have 2 DB's with the same structure of tables.
In one DB the records are more up to data.

When I would like to update the my information, I have to copy 2 table
from one to the other DB.
The ID's are very important that the stay the same number.

I have tried to delete the tables in my destination DB, but I get the
message that I gone destroy the relationships between other tables.

When I delete the records and the copy the records my ID's increment.

What do you want to happen if the same ID exists in both databases? Do you
want to update the data in the record, or add a new record? If you add a new
record, do you have some way to ensure that the related data in other tables
gets transferred too? More information needed!


John W. Vinson [MVP]