runtime error 3709 search key not found when I add a field to a table
Posted on 2013-06-12
I have a database split into backend and front end. When I add an attachment field to one of the tables in the back end I get an error in some of the front end forms. So, to my table tblSubmission I add field SubAttachments, attachment type. Works fine in datasheet view in the back end.
When I close it and open the front end, open the submissions form (based on tblSubmission) and then a command button that opens another form or a report I get the runtime error. I haven't added the new attachment field into any form or query, haven't referenced it anywhere. If I go back into the backend and delete the new field, then back to frontend, everything works fine.
Does anyone have an idea why this would happen?