MSH Library – Attachments is a VBA code library containing procedures and functions for working with MS Access Attachment fields. This library provides VBA code to:

  • Get a list of files in an Attachment field.
  • Copy the contents of one Attachment field to another.
  • Open an Attachment file – and clean up the temporary files!
  • Add new documents/files to an Attachment field.
  • Remove a file from an Attachment field, optionally saving/exporting the file before removing it.
  • Export a document/file from an Attachment field.

MSH Library – Attachments v2014-10 provides procedure and function calls to perform common tasks with Attachment fields, reducing the complexity of these tasks for the programmer.

  • Contains full documentation in PDF format
  • Developed in MS Access VBA (Visual Basic for Applications)
  • For MS Access 2007 (Service Pack 3), MS Access 2010, and later
  • Modules, forms, and other database objects are unlocked and available for inspection and modification.

This is not public domain software. It is licensed to you at no cost.

MSH Library – Attachments v2014-10 and its documentation are released to you under one or more of the GNU Public Licenses. Each pertinent GNU license is included in full as attachments in the MSH Library – Attachments v2014-10.accdb. You may read the pertinent licenses in the MSH Library – Attachments documentation before downloading the source code. You agree to be bound by these license agreements at such time as you utilize the VBA source code, and/or distribute this or new versions of the code and/or its documentation.

Having trouble getting this application to work?

Use the Contact Me button to ask for help.

  • Click the download link. Your browser will display a file download dialog box.
  • Save MSH Library – Attachments v2014-10.zip to any location on your hard drive.
  • When the download is complete, follow these steps:
  • browse to where you saved MSH Library – Attachments v2014-10.zip, and right-click it.
  • Choose “Extract All” from the right-click menu.
  • Follow the prompts in the Extraction Wizard to extract the MSH Library – Attachments v2014-10.accdb file to a location of your choice.
  • Double-click the extracted MSH Library – Attachments v2014-10.accdb file.
  • Windows will launch MS Access and open the database application.
  • Unless you have extracted the .accdb file to a “trusted” location (as defined in your MS Access local configuration), you will see this security warning message under the MS Access ribbon: .
  • Click the Options button to display the Microsoft Office Security Options dialog (shown below).
  • In the Security Options dialog, Select the “Enable This Content” option and click OK. MS Access will now allow the VBA code in the demonstration database to execute.