run-time error: 3426, Help!

[nerd_29]

wazzup guys? i need your help again, an error appears everytime I try to save a new record. it shows this error message:

run time error: 3426:
This action was cancelled by an associated object.

It shows that the an index field on my database is causing the error.
One more thing, there is an inconsistency cause, sometimes the error does not appear and when i run the program again, it shows again. This error is driving me crazy. Is there any way that can make this error eliminate?

I hope that you can help me guys... thanks!

[Bill Crawley]

This looks like a classic case of trying to enter a record where either the primary key already exists or A foreign key in an associated table doesn't exist. Ensure all Constraints are being met first before trying to create a new record.

[dinesh123]

This might help u


http://www.kbalertz.com/kb_189678.aspx


good luck