Append Query, Prevent Duplicates?

[Randy]

Access 2000. I have several laptops which employees enter data in the field
(Out of the office). The data is copied to floppy disks once a week for the
previous week (Sun through Sat), and returned to the office. The floppy
disks are appended to the tables on the main db in the office through a
query. This works ok except for an occasional duplication of data on the
main db. If a floppy is accidently appended to the main db twice, the
result is duplicate data. Or if an employee accidently includes a previous
week that was already appended to the main db, the result is also
duplications of data. The main db is in a computor that is not networked,
it stands alone. Any ideas to prevent the duplication of data that is
appended...Thank you...Randy

 

[Guest]

You can set one of the fields in the main database to except no duplicates
(in table design mode). But if there are currently duplicates in that
database, you may get an error message.

 

[Randy]

Iv'e tried that, but Iv'e had problems with duplicate PK autonumbers from
the different laptops, even though the data is not a duplicate..

 

[John Vinson]

Iv'e tried that, but Iv'e had problems with duplicate PK autonumbers from
the different laptops, even though the data is not a duplicate..

You'll need to use Access Replication - effective, works well, but
it's not for the fainthearted!

Search http://support.microsoft.com for the Access 2000 Replication
White Paper; study it CAREFULLY, and back up your database before
attempting to replicate it.

John W. Vinson[MVP]