Relationship error 3409 -- with solution -
07-26-2011
, 05:01 PM
User was working along doing her usual thing when her database froze
up.
Repair and compact to the rescue -- but not quite. She could still
not enter data in a little two-field table.
I realized that the problem was in the relationship, and eventually
figured out I had a couple of problems.
1) Seems that correcting a corruption on the One side of the
relationship had left an orphan on the Many side. I had to delete the
orphan on the Many side.
2) Still couldn't create the relationship, because of "Invalid field
definition <name> in definition of index or relationship. (Error
3409)." Then I realized that I had lost the primary key on One side
of the relationship. Once I recreated the primary key, I was able to
create the relationship.
I figure that there is about a .001% chance that any one of you will
run into this same problem, and an even smaller chance that you will
need this to help you figure out the solution, but I figure I've done
my civic duty for the day by documenting my experience.
Cheers,
pemigh |