How to prevent users to enter duplicate names in MSAccess?

Question

Is there any way to check duplicate names while filling data in MSAccess?

Answer 1

In your table's design screen, highlight the field you don't want duplicated. Under Indexed (at the bottom), choose "Yes (No Duplicates)"

Should fix it.

Answer 2

Check the INDEXED property of the FIELD OBJECT in the table design window. One of the possible values is "Yes - NO DUPLICATES". The default INDEXED value is "No". If you change the NO to the YES NO DUPLICATES value, that should resolve your issue.

However, that might not be such a good idea. Suppose you had multiple customers named "MATT SMITH". If you have the name field set to "YES, NO DUPLICATES", then ONLY ONE of them can be entered into your database. A better idea might be to set that index on the PHONE NUMBER field, so you can have multiple MATT SMITHs as long as they have different phone numbers.