none
Edits to Word attachments in Access 2016 database record are not saved. RRS feed

  • Question

  • I have an Access database table with an "Attachment" data type for one of the fields.  After opening and editing a previously attached Word document that is attached to a record the edits are not saved to the Word file.

    If I open an Excel spreadsheet and edit it, saving works properly and as expected.

    This is on a Windows 8.1 operating system with Office 365 (2016) Access and Word.

    Is there a setting/update in Access or Word that will rectify the problem?


    Other odd behavior. While in Word and saving, the program defaults to saving the edited document to Onedrive rather than back to the original document in its original location. Browsing to the correct location and "overwriting" the existing document yields the same results in that the edits are not present when the document is reopened; It does not matter if the document is opened from within Access or just with Word.
    Sunday, November 8, 2015 5:06 PM

All replies

  • Hi,

    According to your description, this is a by design behavior. Because, the attachment field saves the attachment file to the temporary Internet folder, not in your original location. Usually in:

    C:\Users\username\AppData\Local\Microsoft\Windows\INetCache\

    Please see this article and the explanation:

    Save changes to an attached file

    1.As needed, use the parent program to edit your file.


    2.Save any changes to the file and close the parent program. Keep in mind that whenever you change an attached file, your changes are saved to the temporary Internet folder on your hard disk drive. See the notes at the end of this section for more information about that folder.


    3.To save your changes permanently, return to Access and, in the Attachments dialog box, click OK.

    A confirmation message appears.


    4.Click Yes to save your changes.

     Notes  

    ##When you open an attached file in its parent program for viewing or editing, Access places a temporary copy of the file in a temporary folder. If you change the file and save your changes from within the parent program, Access saves your changes to the temporary copy. When you return to Access and click OK to close the Attachments dialog box, Access prompts you to save the attached file again. Click Yes to write the changed file to your database, or click No to leave the file untouched in your database.


    ##To find the location of your temporary file folder, follow these steps:

    i.Start Windows Internet Explorer.


    ii.On the Tools menu, click Internet Options.


    iii.On the General tab, under Browsing History, click Settings.

    The Settings dialog box appears. The folder path appears in the Temporary Internet Files section.

    Hope it's helpful.

    Regards,

    George Zhao
    TechNet Community Support


    Please mark the reply as an answer if you find it is helpful.

    If you have feedback for TechNet Support, contact tnmff@microsoft.com.
    Wednesday, November 11, 2015 7:52 AM
    Moderator