I'm trying to append a few records into a table. I've tried append, appendrecord (which I would prefer to use) and append-edit-setfields-post. All attempts appends a new record and enters the data into my table, but then I get the message 'Key Violation' everytime. I can't do anything. I've tried restarting my computer if I have the table open in some invisible instance. Nothing works. What is wrong?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Why do I get 'key violation' when using table.AppendRecord? 1
- Thread starter josefl
- Start date
-
1
- #2
The obvious answer is that you already have a record in your table with the same key as the record you are trying to append.
I suggest that you use the debugger to stop execution at the statement which is raising the Key Violation exception, make a note of the key of the record you are trying to append and then using Database Explorer check if it already exists in the table.
Andreew
I suggest that you use the debugger to stop execution at the statement which is raising the Key Violation exception, make a note of the key of the record you are trying to append and then using Database Explorer check if it already exists in the table.
Andreew
- Thread starter
- #3
- Thread starter
- #4
If 'Name' is your primary key then it must be unique.
The second time you try to append a record with the same Name as one already in the table you will get a Key Violation error.
I don't know your application but 'Name' is not usually a good choice for a primary key. This is why most databases have entities such as a customer reference number to use as a primary key to ensure uniqueness.
You might find it a good idea to read a book about database design. Anybody care to recommend one?
Andrew
The second time you try to append a record with the same Name as one already in the table you will get a Key Violation error.
I don't know your application but 'Name' is not usually a good choice for a primary key. This is why most databases have entities such as a customer reference number to use as a primary key to ensure uniqueness.
You might find it a good idea to read a book about database design. Anybody care to recommend one?
Andrew
- Thread starter
- #7
LucieLastic
Programmer
Alternatively, you have a composite key, made up of several fields.
- Status
Similar threads
- Locked
- Question