| Subject: | [Impressive] Duplicate value in key field !? |
| Posted by: | Hossein Ahmadi (AhmadiSolness…@yahoo.com) |
| Date: | Sun, 17 Aug 2008 |
Hi
I have a simple table in MSAccess, it contain a row field that is Primary
Key and with AutoNumber type.
After inserting some records to the table (for example 74630 records) , ADO
throw an error that my table is damaged(The error origin is that access can
not retrieve records for the operation, because Duplicate record data are
exists in the table)!
After looking on my table i see that Row field contain duplicate data! its
impossible because Row is Primary Key!
Primary Key can not accept duplicate value, However Row is AutoNumber why it
contain duplicate data!?, because MSAccess are filling it after each record
inserting.
Im confusing :(
Thanks for any help
H.Ahmadi