Hi Anup. Access will automatically refuse to import or accept duplicates as long as the relationship between tables is defined and referential integrity set between those tables. Duplicate records would violate referential integrity. Access's own error messages to users about such violations are low-level and not user-friendly, so developers would normally replace these with their own.
If you are looking to block duplicates on a table that does not relate to any other you can do so by defining the field or fields which make up the primary key for that table, as there can be no duplicates of primary keys.
It all comes down to ensuring tables are correctly defined, with appropriate primary keys (not just autonumber values if possible).
-Stewart
Thanx Stewart for your prompt reply.
My problem is that I want to avoid those duplicates which is having same value for all fields. consider below example:-
Suppose Field 1 contains A ,Field2 contains B and Field3 contains C...... etc.
If I import Field1 and field2 with similar values access should accept it and should not throw any errors.
But when I will upload all the fields i.e. Field1, field2 and field3..... with same values, then access should deny accepting it. My table does have any relationship with any other table.
Since I cant make primary keys to any field as I am accepting duplicates where some of the fields are matching in the table. But i want all the fields with similar value matched access should avoid it.