updating multiple databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My problem is that I have 3 copies of the same databse running on three
computers that cannot be networked, and each has autonumber for forms like
Invoice, quotes etc. I need to collate the information monthly from the three
computers to my computer, but the forms overide each other.(ie three invoice
number 1, three number 2 etc) Is there a way I can collate the data? Thanks.
 
Hi Adam,

Add a field to each table where these "collisions" could be a problem
and use it to identify the computer where the record was created.
Include this new field in the primary key of each table.

So where now you may have two records with autonumber IDs of (say) 4352,
you will then have one record 4352, "London" and another 4352, "Tokyo".
 
Thanks for your response. I'll try it.
Adam

John Nurick said:
Hi Adam,

Add a field to each table where these "collisions" could be a problem
and use it to identify the computer where the record was created.
Include this new field in the primary key of each table.

So where now you may have two records with autonumber IDs of (say) 4352,
you will then have one record 4352, "London" and another 4352, "Tokyo".
Click to expand...
 
Back
Top