Access Form - Attachment Cannot Be Added (Sharepoint List)

  • Hello,

    Thank you for your help in advance. I have a Sharepoint list that I would rather use Access as my interface for instead of Sharepoint's forms. I have a simple list in Sharepoint, it's 7-8 columns and each form adds a new row to the list. In general I have the form created and everything works except for the attachment. In Sharepoint, the same form can hold attachments just fine and post them to the same new row without any issues, but when I try to do the same thing with Access, it gives me the 'Attachment cannot be added until a new row has been committed.' error. This error comes up as soon as you click to add an attachment, as if it is trying to add the attachment to the Sharepoint list right then. The Sharepoint form seems to hold the attachment and add it when it adds the rest of the information to the row, I need Access to do the same thing.

    Is there a way to tell Access just to hold on to the attachment until it commits the rest of the information to the row?

    Thank you.