microsoft.public.access.gettingstarted

On Oct 22, 2:39 pm, Hendri...@gmail.com wrote:
> I ran the append query and it gave me a result but it also gave me an
> error message saying "Microsoft accees set 0 fields to Null due to a
> type conversion failure, and it didn't add 40000 records to the table
> due to key violations, 0 records due to loc violation, and 0 records
> due to validation rule violations. How do I correct the key violation?
>
> On Oct 22, 12:41 pm, mcnews wrote:
>
> > On Oct 22, 11:43 am, Hendri...@gmail.com wrote:
>
> > > I'm using Access 97 and wanted to know if there is a way for me to
> > > remove duplicates.
>
> > > I can also use Access 00 and 03 but since other who don't have them
> > > will be using the database I would prefer to use 97. But if I'm unable
> > > to remove duplicates in 97 but can in 00 or 03 please let me know.
>
> > duplicate records?
>
> > make a copy of the table (structure only).
> > create a primary key that combines the fields that you don't want
> > duplicated.
> > create an append query from old table to new table.
> > dupes will not be imported.

the key violation is what keeps the dupes out.