Windows Forum

Ask something
Discussion Locked

MS ACCESS 97

0 helpful
1 reply

by kjackson_swc

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a access program setup to hyperlink to various software. When I click the hyperlink the following error msg appears: "The changes you requested to the table were not successful because they would creae duplicate values in the index, primary key, or relationship. Change the data in the fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again." How do I correct this...

1 reply

by stillatit

If you have fields on your form, when you click the hyperlink you are leaving the record, so the form fields try to update the database. If this results in a duplicate record (like blank) or a blank primary key, you will get the error you describe.
Try setting up a condition that activates when you hyperlink out (might be deactivate, might be something else). When that condition trips, execute a routine that checks the screen fields and prevents trying to create a bad record.

Good luck.

This discussion is closed to new replies.