Autonumber in two copies of database to be combined

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I would like to allow an employee to work off the network on a copy of a
database with an autonumber field. she will need a copy of the database
(17,000+records) because they are of sections of roads that when worked on,
the info from one record gets split or added to and appended to the end of
the database with the new information. I can't stop records from being added
while she is working on the copy, because other employees access it
regularly. My plan was to just append the new records she creates, when she
is finished, but by then there will be duplicate autonumbers.
Can I just delete the auto number in her copy and append her changes to
the main database? What problems will I encounter? Any suggestions greatly
appreciated
thanks in advance
Ken
 
If her "off-line" data is only updating/appending to a single table, you
should be able to simply append her new records to your "on-line" table
without using her autonumber field. However, if she might be adding "child"
records of the main table this will cause other issues.
 
Back
Top