Working with 2 copies of DB

[William Buchanan]

Hi
I have 2 copies of my database on separate standalone machines. I now
need to get the data from one table brought from one of the copies into
the other to get a full set of data. I have tried copy paste but that
didn't work. The table has an autonumber field (don't know if this is
causing problem).
Any ideas as to how I can do this would be appreciated.

Thanks

William Buchanan

[John Vinson]

Yes, the autonumber will certainly cause problems - new records in the
two databases will be created with the same autonumber, bollixing up
all your relationships!

Take a look at Replication in the online help. It's a BIG job. Read
the instructions carefully.

John W. Vinson[MVP]
http://go.compuserve.com/msdevapps?loc=us&access=public

[G Bramfield]

You may also want to take a look at replication/synchronization.

Regards, G.
William Buchanan <buck.b...@zetnet.co.uk> wrote in message
news:396a2741$0$11...@znews.zetnet.co.uk...

> Hi
> I have 2 copies of my database on separate standalone machines. I now
> need to get the data from one table brought from one of the copies into
> the other to get a full set of data. I have tried copy paste but that
> didn't work. The table has an autonumber field (don't know if this is
> causing problem).
> Any ideas as to how I can do this would be appreciated.
>

> Thanks
>
> William Buchanan
>
>
>
>
>

[Joan Wild]

Certainly look at replication, but in the mean time to get the information
merged:
You indicate that it's just information from one table you need. Import
this table into your db and then use an append query to add the information
(except auto #) to your existing table.
Joan

[William Buchanan]

Thanks for the help!
The solutions all seem viable.

William Buchanan