Access database attachment

Conernesto used Ask the Experts™
I created a field in a table called attachment. This filed is for attaching PDFs or Excel files. I was able to attach one pdf and open it. Can I attach two pdfs? If yes, how do I select which pdf to open?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Generally, I avoid saving attachments in my Access databases.  Instead, I save the path to the file.

Yes, you can attach multiple attachments to a single record in your table.  Are you attempting to do this via code, or while viewing the table?


I am attempting to do this while viewing the table. I do like the path to the file option. How do I do this?
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

So, to be clear, ...your field is an "Attachment" Datatype specifically?

If so, ...and I am understanding your question, can select another PDF by simply double clicking the attachment field (the paperclip Icon for that record) again, and selection "Add"

You can select which PDF to open by (again) double clicking the attachment field (the paperclip Icon for that record) again, and clicking the PDF you want to open, ...then clicking "Open".
attachment field datatype
Daniel PineaultPresident / Owner CARDA Consultants Inc.
Distinguished Expert 2018

I'd recommend you take the time to read Adding Attachments to an Access Database and review the sample database.
Software & Systems Engineer
You can always store the PDFs as BLOBs and avoid the hassle with the Attachment fields that in the end cause more problems than solutions.
If you have a LOT of files Access is not very good for storing files better use SQLite if you are a single user or Firebird if your application is for multiple users.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial