|
Home > Archive > MS Access Multiuser > May 2005 > Copy data
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Hi,
how do I copy data from a table in a database to a table in another
database? All keys (AutoNumber) need to be the same in booth databases so
that the relations still works.
Thanks,
Julia
| |
| Rick B 2005-05-12, 9:25 am |
| Personally, I wouldn't!
Why not just link the "other" database to the table in the first database?
If you copy the data, then you will constantly be trying to keep the two in
synch. Just link to it.
--
Rick B
"Julia" <Julia@discussions.microsoft.com> wrote in message
news:D3168D38-ED7C-4DE7-8398- 119A611C323E@microso
ft.com...
> Hi,
> how do I copy data from a table in a database to a table in another
> database? All keys (AutoNumber) need to be the same in booth databases so
> that the relations still works.
>
> Thanks,
> Julia
|
|
|
|
|