Microsoft Office Tutorials and References
In Depth Information
Access Data Types
The Attachments dialog box shows you all the files that
are linked to your field.
Here’s what you can do in the Attachments window:
• Add a new attachment. Click the Add button. Then browse to a new file and
click OK. You’ll see the file appear at the bottom of the list.
• Delete an attachment. Select the attachment in the list and then click Remove.
• Save a copy of an attachment. Select the attachment, click Save As, and then
browse to a location on your computer. Or, click Save All to save copies of all
the attachments in this field. If you change these copies, you don’t change the
attachment in the database.
• View an attachment. Select the attachment and then click Open. Access copies
the attachment to a temporary folder on your computer, where Internet content
is cached, and then opens it in the associated program. For example, .doc files
get opened in Microsoft Word.
• Edit an attachment. This process is similar to viewing an attachment. First,
select the attachment and click Open. Begin editing the document, but make
sure you don’t close the Attachments window in Access. When you’re finished,
save the temporary document (without changing its name or moving it to a new
folder), switch back to Access, and click OK in the Attachments window. Access
notices your changes and asks if it should copy the updated version of the file to
your database, replacing the original (Figure 26-19, top).
Unfortunately, the Attachment data type doesn’t give you a lot of control. Here are
some of its limitations:
• You can’t restrict the number of attachments allowed in an attachment field.
All attachment fields allow a practically unlimited number of attachments (al-
though you can’t attach two files with the same name).
• You also can’t restrict the types of files used for an attachment.
• You can’t restrict the size of the files used for an attachment.