Preventing Duplicates

  • Thread starter Thread starter little_rascals
  • Start date Start date
L

little_rascals

Hi, I am supposed to import data from a text file.
The data consists of 10 different fields which is to be imported into
Microsoft Access table.
Is there any way i can check for duplicates to prevent the user from
importing the same set of information twice when the "Import" button is
accidentally clicked more than once.

The data in the text files can be repetitive so there is no primary key
in the table. Therefore, i cannot make sure of multiple index!


Thank You!!!
 
The data in the text files can be repetitive so there is no primary key
in the table. Therefore, i cannot make sure of multiple index!
Click to expand...

So two files could (theoretically) be two different files, both of
which need to be imported... but could be exact duplicates of one
another.

Given that... no. There's no way to look at two identical pairs of
records and say "this pair is a duplicate, but this pair is ok".

You'll need - at the least - to keep track of which files have been
imported in a separate table (which still leaves the possibility of
someone renaming a file).
 
Back
Top