If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
duplicate values for primary key
all of the sudden my table's autonumber field is using numbers that have
already been defined. therefore, I am getting an error message to change the data in field, remove the index, redefine the index to permit duplicate entries. this table has relationships with other tables - any of the above it will not let me do. why would the autonumber start reusing numbers (there are only 195 records in this table currently)? I saw something about restarting the numbering by appending the table to a new temp table, but got lost in the instructions, I guess, since it didn't work. |
#2
|
|||
|
|||
duplicate values for primary key
See:
Fixing AutoNumbers when Access assigns negatives or duplicates at: http://allenbrowne.com/ser-40.html for an explanation of the causes and solutions. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Frank" wrote in message ... all of the sudden my table's autonumber field is using numbers that have already been defined. therefore, I am getting an error message to change the data in field, remove the index, redefine the index to permit duplicate entries. this table has relationships with other tables - any of the above it will not let me do. why would the autonumber start reusing numbers (there are only 195 records in this table currently)? I saw something about restarting the numbering by appending the table to a new temp table, but got lost in the instructions, I guess, since it didn't work. |
Thread Tools | |
Display Modes | |
|
|