MS Access Working with Attachment Data Types

Although I highly recommend completely avoiding the use of Attachment Data Types, it is still a common question in discussion forums so I thought I’d put together a simple demonstration database.  In the following sample I demonstrate a few ways to work with attachment fields such as, how to:

  • Create subform to display all the attachments
  • Save an individual attachment to a folder of your choosing
  • Save all the attachments to a folder of your choosing
  • Open/Preview an attachment
  • Delete an attachment

In my sample I work with images (png), but it could be any type of file (docs, xls, pdfs, …).

Disclaimer/Notes:

If you do not have Microsoft Access, simply download and install the freely available runtime version (this permits running MS Access databases, but not modifying their design):

Microsoft Access 2010 Runtime
Microsoft Access 2013 Runtime
Microsoft Access 2016 Runtime
Microsoft 365 Access Runtime

All code samples, download samples, links, ... on this site are provided 'AS IS'.

In no event will Devhut.net or CARDA Consultants Inc. be liable to the client/end-user or any third party for any damages, including any lost profits, lost savings or other incidental, consequential or special damages arising out of the operation of or inability to operate the software which CARDA Consultants Inc. has provided, even if CARDA Consultants Inc. has been advised of the possibility of such damages.

 

Download a Demo Database

Feel free to download a demo copy by using the link provided below:

Download “Access Working with Attachment Data Types (Access 2013 x32 accdb)” AttachmentDataType.zip – Downloaded 9188 times – 289.59 KB

Version History

V1.000 (2017-07-11)

  • Initial release

Useful Links