This Error is driving me crazy!!

Please help - I have a simple database with customer
orders and information and I have suddenly come to a dead
end trying to add a new record.

I can add one new record without any problem but when I
try to add a second one, I get the Error message "The
changes you requested to the table were not successful
because they would create duplicate values in the index,
primary key, or relationship. (Error 3022)"

I have checked the relationships, indexes and Primary key
(which is an autonumber - CustomerID, with a single
relationship to my Orders Table)

I am nowhere near reaching the size limit (just over 3MB
so far) and am going mad trying to work out why I am
suddenly getting this error.

Please Help Me!!

Do any of the indexed fields contain a Null value? And is the index that
includes that field have "Ignore Nulls" set to No?

--

Ken Snell
MS ACCESS MVP

"Ali" wrote in message
...
Please help - I have a simple database with customer
orders and information and I have suddenly come to a dead
end trying to add a new record.

I can add one new record without any problem but when I
try to add a second one, I get the Error message "The
changes you requested to the table were not successful
because they would create duplicate values in the index,
primary key, or relationship. (Error 3022)"

I have checked the relationships, indexes and Primary key
(which is an autonumber - CustomerID, with a single
relationship to my Orders Table)

I am nowhere near reaching the size limit (just over 3MB
so far) and am going mad trying to work out why I am
suddenly getting this error.

Please Help Me!!

I have checked all the indexes and changed any that
specified 'Ignore Nulls' as No to Yes but I still get the
problem.

Ali

Do any of the indexed fields contain a Null value? And
is the index that
includes that field have "Ignore Nulls" set to No?

--

Ken Snell
MS ACCESS MVP

"Ali" wrote in
message
...
Please help - I have a simple database with customer
orders and information and I have suddenly come to a
dead
end trying to add a new record.

I can add one new record without any problem but when I
try to add a second one, I get the Error message "The
changes you requested to the table were not successful
because they would create duplicate values in the
index,
primary key, or relationship. (Error 3022)"

I have checked the relationships, indexes and Primary
key
(which is an autonumber - CustomerID, with a single
relationship to my Orders Table)

I am nowhere near reaching the size limit (just over
3MB
so far) and am going mad trying to work out why I am
suddenly getting this error.

Please Help Me!!



.

I can't see the data that you're trying to load, so I'm very limited in what
suggestions to make beyond this.

Can you post the info table structure, table indices, and data that
loaded and data that is rejected?

--

Ken Snell
MS ACCESS MVP

"Ali" wrote in message
...
I have checked all the indexes and changed any that
specified 'Ignore Nulls' as No to Yes but I still get the
problem.

Ali

Do any of the indexed fields contain a Null value? And
is the index that
includes that field have "Ignore Nulls" set to No?

--

Ken Snell
MS ACCESS MVP

"Ali" wrote in
message
...
Please help - I have a simple database with customer
orders and information and I have suddenly come to a
dead
end trying to add a new record.

I can add one new record without any problem but when I
try to add a second one, I get the Error message "The
changes you requested to the table were not successful
because they would create duplicate values in the
index,
primary key, or relationship. (Error 3022)"

I have checked the relationships, indexes and Primary
key
(which is an autonumber - CustomerID, with a single
relationship to my Orders Table)

I am nowhere near reaching the size limit (just over
3MB
so far) and am going mad trying to work out why I am
suddenly getting this error.

Please Help Me!!



.

Hi Ken

Thanks for your help but I think I have solved the
problem - some default values appear to have sneaked in
to a couple of the fields and removing these has also
removed the problem...

Thanks again
Ali

-----Original Message-----
I can't see the data that you're trying to load, so I'm
very limited in what
suggestions to make beyond this.

Can you post the info table structure, table
indices, and data that
loaded and data that is rejected?

--

Ken Snell
MS ACCESS MVP

"Ali" wrote in
message
...
I have checked all the indexes and changed any that
specified 'Ignore Nulls' as No to Yes but I still get
the
problem.

Ali

Do any of the indexed fields contain a Null value? And
is the index that
includes that field have "Ignore Nulls" set to No?

--

Ken Snell
MS ACCESS MVP

"Ali" wrote in
message
...
Please help - I have a simple database with customer
orders and information and I have suddenly come to a
dead
end trying to add a new record.

I can add one new record without any problem but
when I
try to add a second one, I get the Error
message "The
changes you requested to the table were not
successful
because they would create duplicate values in the
index,
primary key, or relationship. (Error 3022)"

I have checked the relationships, indexes and
Primary
key
(which is an autonumber - CustomerID, with a single
relationship to my Orders Table)

I am nowhere near reaching the size limit (just over
3MB
so far) and am going mad trying to work out why I am
suddenly getting this error.

Please Help Me!!



.



.