Idexed problem

#1 (**permalink**) 28-Jul-2006, 08:29 AM

I have a table named:tbl_BOMinfo
and I have the a field named: Base_ID as Data type = text

and I have it Idexed to: Yes (No Duplicates) but at the time to use it, it
allow the duplicates...( using Forms and Table)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12430-idexed-problem.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12430

what is wrong?

Note: this is the second column since my first column is the AutoNumber
field and it also is Idexed to :Yes (No Duplicates) but it's working fine.

could you help please.
--
Lorenzo DÃ*az
Cad Technician

*

#2 (**permalink**) 28-Jul-2006, 08:29 AM

ldiaz wrote:
> I have a table named:tbl_BOMinfo
> and I have the a field named: Base_ID as Data type = text
>
> and I have it Idexed to: Yes (No Duplicates) but at the time to use
> it, it allow the duplicates...( using Forms and Table)
>
> what is wrong?

Either...

It is not indexed as you think it is.

You are not entering duplicates when you think you are.
(you do know it won't give an error until you save, right?)

The file is corrupted.

I think the last is actually not very likely, but you can always try
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12430
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12430
compact/repair on the file to see if it makes a difference.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

#3 (**permalink**) 28-Jul-2006, 08:29 AM

Hi Rick, you are right.

the file was corrupted, I have Compacted & repaired my DB and now the field
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12430
is not allowing the duplicates values.

thank you so much for your help.
--
Lorenzo DÃ*az
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12430
Cad Technician

"Rick Brandt" wrote:

> ldiaz wrote:
> > I have a table named:tbl_BOMinfo
> > and I have the a field named: Base_ID as Data type = text
> >
> > and I have it Idexed to: Yes (No Duplicates) but at the time to use
> > it, it allow the duplicates...( using Forms and Table)
> >
> > what is wrong?
>
> Either...
>
> It is not indexed as you think it is.
>
> You are not entering duplicates when you think you are.
> (you do know it won't give an error until you save, right?)
>
> The file is corrupted.
>
> I think the last is actually not very likely, but you can always try
> compact/repair on the file to see if it makes a difference.
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
>
>
>