microsoft.public.access

I figured it out, it was the data, not me. When I would re import the second
time it was bringing back all of the records that were blank in one of the
indexed fields. So I assume when I imported the first time it changed them
to a null value and then when I did it the second time it saw them coming in
as blank. Not sure but I fixed it!

"John W. Vinson" wrote:

> On Thu, 18 Oct 2007 08:14:04 -0700, Ben Watts
> wrote:
>
> >I am having a bit of trouble here plus I am relatively new to this. I have
> >created table and 4 of the fields I use as one index to prevent duplicates.
> >So what I have done is imported my data from an excel sheet and then
> >reimported the exact same sheet to see if the index would work. It allowed
> >some of the records into the database. Why is it doing this?
>
> Probably because you made some sort of mistake... which we can't see from
> here!
>
> Please post the relevant fields of your table and the specifications of the
> index, and some examples of the records that are getting in that you don't
> want.
>
> John W. Vinson [MVP]
>