primary key

[handsomealso]

I have new database in this database i make primary key to field (ID NUMBER)



I enter data in this database just copy and past

If i enter any ID Number which is already in database , this database is stock

how i avoid this problem and how i let this database to accept othe ID Number which is not in database and ignore other?

[JoeM]

You could import or Copy and Paste your data into a new, temporary table, which has the same structure as your "real" table, but no data in it.
You can then do an Unmatched query between the temporary table and real table to find all the "new" records, and then use an Append Query to copy them to your "real" table.