G
godiva
Hi,
Here's the problem that I'm up against:
I have an append query. When I run the append query, it says that it
can't add records due to a key violation. I check indexes on the
table and review the data. This set of data does not exist anywhere
in the table and it is not in violation of any indexes on the table.
It will append 5 of the 127 records into the table. If I keep running
it, it eventually appends more and more into the table.
I have even tried appending the records from a select query using one
table instead of the append query looking at joined tables. The error
still happens.
I've copied the structure of the table the records are appending to.
Then the records append without a problem. The current table has
around 125k records in it. I am now wondering if it happens to be the
size of the table that is the problem. Even making a copy of the
structure, then appending the records into the new table from the old
then running the append query still gets the same result. I've even
attempted to move the records using recordsets and moving one by one
just to be told that I was duplicating data (that wasn't even in the
table).
Any suggestions on how I can beat this?
I've run compact and repair on the data side of it as well as the
front end.
thanks
MM
Here's the problem that I'm up against:
I have an append query. When I run the append query, it says that it
can't add records due to a key violation. I check indexes on the
table and review the data. This set of data does not exist anywhere
in the table and it is not in violation of any indexes on the table.
It will append 5 of the 127 records into the table. If I keep running
it, it eventually appends more and more into the table.
I have even tried appending the records from a select query using one
table instead of the append query looking at joined tables. The error
still happens.
I've copied the structure of the table the records are appending to.
Then the records append without a problem. The current table has
around 125k records in it. I am now wondering if it happens to be the
size of the table that is the problem. Even making a copy of the
structure, then appending the records into the new table from the old
then running the append query still gets the same result. I've even
attempted to move the records using recordsets and moving one by one
just to be told that I was duplicating data (that wasn't even in the
table).
Any suggestions on how I can beat this?
I've run compact and repair on the data side of it as well as the
front end.
thanks
MM