dbTalk Databases Forums  

Relationship error 3409 -- with solution

comp.databases.ms-access comp.databases.ms-access


Discuss Relationship error 3409 -- with solution in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
pemigh
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.