Idexed problem

[Guest]

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?

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.

 

[Rick Brandt]

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.

 

[Guest]

Hi Rick, you are right.


the file was corrupted, I have Compacted & repaired my DB and now the field
is not allowing the duplicates values.


thank you so much for your help.