[AccessD] Compound Unique Keys...Again

[Gustav Brock]

Hi Charlotte

Haven't seen this, but couldn't you link the textfile, then run a grouping append query using the linked file as source?

/gustav

________________________________________
Fra: AccessD <accessd-bounces at databaseadvisors.com> på vegne af Charlotte Foust <charlotte.foust at gmail.com>
Sendt: 2. april 2015 16:33
Til: Access Developers discussion and problem solving
Emne: [AccessD] Compound Unique Keys...Again

I'm beating my head against the wall on this.  I set a unique key on
multiple fields and Access 2010 allows me to import the same data
repeatedly!  Since the import is from a text file which has no unique
values in it, I'm finding it impossible to keep duplicates out.

Anyone else encountered this?  I may have to set those multiple fields to
the PK, which is a nuisance.


Charlotte