Email Data Collection, Update existing info not an option.

[johnb11]

Please god all mighty help me, I h*TE Microsoft at times.... I am really struggling with the collect data feature as it makes no sense why I have some tables that will show or allow update existing info and other tables where this is not an option... I cant figure it out! it is the most frustrating.... I really need this working, just don't know how to go about figuring out what the problem is. any ideas or suggestions. would be helpful. there is data in both tables,,, I can edit both tables manually, however on table gives me the option to collect data through email and update existing, and in the other table it doesn't... any help would be greatly , greatly appreciated. thanks all.

[June7]

Do you want to provide db for analysis? Follow instructions at bottom of my post.

Be aware, MS has removed Collect Data from Access 2013. Can't create new Collect Data specifications but supposed to be able to run if created in earlier versions.