How to Add Attachment Control to MS Access

Most people treat MS Access like a basic table tool. They store names, numbers, and dates — and call it a day.

But here’s what they’re missing: Access can store entire files — PDFs, images, contracts, screenshots — right inside your database records. No external folders. No broken file paths. No “I can’t find that document” emails at 9 PM.

The feature that makes this possible is called the Attachment control. And once you know how to use it, the way you think about your database changes completely.

This guide walks you through every step — from enabling the right field type to adding the control to your form — so you can start attaching files to your records today.

Quick Stat: Microsoft Office is installed on over 1.2 billion devices worldwide, and MS Access remains one of the most widely used desktop database tools for small to mid-sized businesses and internal teams. Despite this, fewer than 20% of Access users ever use its Attachment field — leaving a powerful feature completely untapped.

What Is an Attachment Control in MS Access?

An Attachment control is a form element in MS Access that lets you store one or more files directly inside a database record.

Think of it like a paper clip on a sticky note — except the sticky note is a database row, and the paper clip can hold documents, images, spreadsheets, or any other file type you need.

When you click the attachment control on a form, a dialog box opens. You can then:

• Add new files to the record
• Open existing attachments directly from the database
• Remove files you no longer need
• Save attachments to a location on your computer

This is different from simply storing a file path as text. With the Attachment data type, the actual file is stored inside the .accdb database — which means it travels with the database and doesn’t break when folders get reorganized.

Why This Matters More Than You Think

Here’s a scenario that plays out every week in offices across the world:

A manager opens a client record in Access, sees a note that says “See contract in shared drive > Clients > 2022 > Smith_final_v3.docx” — and that file no longer exists. The folder was reorganized six months ago, and nobody updated the record.

With the Attachment control, the file lives inside the record. There’s no path to break. No folder to reorganize. The data and the document stay together.

Other real-world use cases:

• Storing signed contracts alongside client records
• Attaching photos of products or inventory items
• Keeping ID documents tied to employee records
• Saving invoices linked to transaction entries
• Embedding screenshots for support or bug tracking workflows

What You Need Before You Start

Before adding an Attachment control to a form, make sure:

1. Your database uses the .accdb format — not the older .mdb format. The Attachment data type is only available in Access 2007 and later. If your file ends in .mdb, save a copy as .accdb first.
   
   
2. Your table has an Attachment field — the form control links to an underlying table field. You’ll need to add one if it doesn’t exist yet.
   
   
3. You have design access — you need permission to edit the table structure and the form layout. If you’re working in a shared database, check with the admin.
   
   

How to Add an Attachment Field to Your Table

The Attachment control on a form is only as useful as the field behind it. Here’s how to add the right field type to your table first.

Step 1 — Open your table in Design View

Go to the Navigation Pane on the left. Right-click the table you want to modify. Select Design View.

Step 2 — Add a new field row

Scroll to the first empty row in the field list. Click in the Field Name column and type a name — for example, SupportingDocs or Attachments.

Step 3 — Set the data type to Attachment

Click the Data Type dropdown for that row. Select Attachment from the list.

That’s it. Access will automatically configure the field properties. You don’t need to set a field size or format — the Attachment type manages that internally.

Step 4 — Save the table

Press Ctrl + S or click the Save icon. Access may warn you that you’re changing the table structure — click Yes to confirm.

Important: You can only have one Attachment field per table in MS Access. This is a built-in limitation. However, each Attachment field can store multiple files per record, so in most cases a single field is more than enough.

How to Add the Attachment Control to a Form

Now that your table has an Attachment field, you can add the control to your form.

Method 1 — Using the Form Wizard (Easiest)

If you’re building a new form from scratch:

Step 1 — In the Navigation Pane, select your table.

Step 2 — Go to the Create tab in the ribbon. Click Form.

Access will auto-generate a form with all the fields from your table — including the Attachment field. The Attachment control appears automatically, ready to use.

Method 2 — Adding It to an Existing Form in Design View

If you already have a form and want to add the Attachment control to it:

Step 1 — Open the form in Design View

Right-click your form in the Navigation Pane. Select Design View.

Step 2 — Open the Field List

Go to the Design tab in the ribbon. Click Add Existing Fields. A panel will appear on the right side showing all available fields from the linked table.

Step 3 — Drag the Attachment field onto the form

Find your Attachment field in the Field List panel. Click and drag it onto the form canvas. Access will place an Attachment control on the form — it looks like a small paperclip icon box.

Step 4 — Resize and position the control

Click and drag the edges of the control to resize it. Move it to where you want it on the form.

Step 5 — Save and switch to Form View

Press Ctrl + S. Then click View > Form View to test the control.

How the Attachment Control Works in Form View

Once you’re in Form View, here’s how to use the Attachment control:

To add a file: Double-click the attachment control (or right-click and choose Manage Attachments). The Attachments dialog opens. Click Add, browse to your file, and click Open. Then click OK to save.

To open an attached file: Double-click the control. In the dialog, select the file and click Open. The file opens in its default application.

To remove a file: Open the Manage Attachments dialog. Select the file and click Remove. Click OK to confirm.

To save an attached file to your computer: Open the Manage Attachments dialog. Select the file and click Save As. Choose a location on your computer.

Key insight: The navigation arrows on the Attachment control let you cycle through multiple attachments in the same record without opening the full dialog. If a record has three files attached, you’ll see a counter like “1 of 3” and can click forward/backward to browse them inline.

How to Add the Attachment Control Using the Toolbox

If your Attachment field doesn’t appear in the Field List (for example, if you’re working with a loosely bound form), you can add the control manually.

Step 1 — Open your form in Design View.

Step 2 — Go to the Design tab. In the Controls group, look for the Attachment icon — it looks like a paperclip.

Step 3 — Click the Attachment icon. Then draw the control on your form by clicking and dragging on the canvas.

Step 4 — With the control selected, open the Property Sheet (F4). Go to the Data tab. Set the Control Source to your Attachment field name.

Step 5 — Save and test in Form View.

Formatting and Customizing the Control

Once the control is on your form, you can make it look and behave better with a few simple adjustments.

Change the label text Click the label next to the control (it usually defaults to the field name). Click once more to edit the text. Change it to something clear like “Attached Documents” or “Upload Files.”

Resize the control for visibility A small attachment control can frustrate users. Drag the edges to make it at least 2–3 inches wide. This improves usability significantly.

Show a picture attachment inline If the attachment is an image, Access can display it directly in the control rather than showing just a paperclip icon. In Design View, select the control, open the Property Sheet, and find the Display As property. Change it to Image (instead of Icon). Now image attachments will render visually in the form.

Lock the control If you want users to view attachments but not add or remove them, set the Enabled property to No in the Property Sheet. This makes the control read-only.

How to Use Attachment Controls in Datasheet View

You can also work with attachments directly from a table’s Datasheet View — without a form at all.

Each cell in an Attachment column shows a paperclip icon with a count (e.g., 📎2 means two files are attached). Double-click the cell to open the Attachments dialog and manage files from there.

This is useful for quick data entry tasks where building a full form isn’t necessary.

File Size and Performance Considerations

This is the part most tutorials skip — and it matters.

MS Access embeds files inside the database file itself. Every attachment you add increases the size of your .accdb file. This can get out of hand quickly if you’re not careful.

A few benchmarks to keep in mind:

• MS Access has a maximum database size of 2 GB
• A single high-resolution image can be 3–8 MB
• A scanned PDF contract might be 500 KB–2 MB
• Embedding 500 documents at 1 MB each = 500 MB — nearly 25% of your total database limit

Best practices for managing file size:

• Compress images before attaching them. Tools like TinyPNG or Squoosh can reduce image sizes by 60–80% with no visible quality loss.
• Use PDF for documents rather than DOCX or XLSX — PDFs are typically smaller and more portable.
• Archive old records regularly to keep the active database lean.
• Split your database if it grows large — keep the backend (tables) separate from the frontend (forms/queries) using Access’s built-in Database Splitter.
• Consider linked attachments for very large files: store the file on a shared drive and save the path as a Hyperlink field instead.

Stat to remember: Studies on database performance show that databases over 1 GB in size experience significantly slower query times in MS Access. Keeping your database lean isn’t just good hygiene — it’s a performance necessity.

Common Errors and How to Fix Them

“The Attachment data type is not available” You’re likely working in the older .mdb format. Save your database as .accdb via File > Save As > Access Database (.accdb).

“You can only have one attachment field per table” Access enforces this limit. If you need to store different categories of files (e.g., “Contracts” vs “Photos”), create a related table with its own Attachment field and link the two tables.

The control appears but shows no files Check that the Control Source property of the control is correctly set to your Attachment field name. An unbound control will look right but store nothing.

Attachments dialog opens but files won’t open Access relies on your Windows file associations to open attachments. If a file won’t open, Windows may not have the right application associated with that file type. Check your default apps in Windows Settings.

Database growing too fast See the file size section above. Also, compact and repair your database regularly via Database Tools > Compact and Repair Database. This removes wasted space and can dramatically reduce file size.

Working With Attachments in Queries and Reports

Once your data includes attachments, you might want to reference them in queries or display thumbnails in reports.

In queries: You can filter or sort records that have attachments by querying the .FileName property of the Attachment field. For example:

[Attachments].[FileName] Like “*.pdf”

This lets you find all records where a PDF is attached — useful for compliance or audit workflows.

In reports: Add the Attachment control to a report the same way you add it to a form — from the Field List or the Controls toolbox. Set the Display As property to Image if you want visual thumbnails (great for product catalogs or photo directories).

Exporting Records With Attachments

When you export data from MS Access to Excel or CSV, attachments do not export — they’re binary data that plain text formats can’t hold.

To preserve attachments during a migration:

• Export to a new Access database (File > Export > Access Database)
• Use a macro or VBA script to extract and save files to a folder, then re-import
• Consider a platform migration tool if you’re moving to a more scalable database like SQL Server

Industry note: According to Gartner, over 60% of small business data is stored in desktop tools like MS Access and Excel. As teams grow, many eventually migrate to cloud-based CRMs or full relational databases — but for smaller operations, Access remains a practical, cost-effective choice.

A Quick VBA Shortcut for Power Users

If you manage a larger database, you can automate the extraction of attachments using VBA. Here’s a basic snippet:

Sub ExtractAttachments()

    Dim db As DAO.Database

    Dim rs As DAO.Recordset2

    Dim rsA As DAO.Recordset2

    Dim fld As DAO.Field2

    Set db = CurrentDb

    Set rs = db.OpenRecordset(“YourTableName”)

    Set fld = rs.Fields(“Attachments”)

    Do While Not rs.EOF

        Set rsA = fld.Value

        Do While Not rsA.EOF

            rsA.Fields(“FileData”).SaveToFile “C:\Exports\” & rsA.Fields(“FileName”).Value

            rsA.MoveNext

        Loop

        rs.MoveNext

    Loop

    MsgBox “Extraction complete.”

End Sub

Replace “YourTableName” with your actual table name and update the export path. This will save every attachment from every record into a folder on your computer.