Export (0) Print
Expand All

Attachment Object (Access)

This object corresponds to an attachment control. Use an attachment control when you want to manipulate the contents fields of the attachment data type.

Version Added: Access 2007

Note Note

You can attach files only to databases that you create in Office Access 2007 and that use the new .accdb file format. You cannot share attachments between a Office Access 2007 (.accdb) database and a database in the earlier (.mdb) file format.

You can attach a maximum of two gigabytes of data (the maximum size for an Access database). Individual files cannot exceed 256 megabytes in size.

Supported image file formats

Office Access 2007 supports the following graphic file formats natively, meaning the attachment control renders them without the need for additional software.

  • BMP (Windows Bitmap)

  • RLE (Run Length Encoded Bitmap)

  • DIB (Device Independent Bitmap)

  • GIF (Graphics Interchange Format)

  • JPEG, JPG, JPE (Joint Photographic Experts Group)

  • EXIF (Exchangeable File Format)

  • PNG (Portable Network Graphics)

  • TIFF, TIF (Tagged Image File Format)

  • ICON, ICO (Icon)

  • WMF (Windows Metafile)

  • EMF (Enhanced Metafile)

Supported formats for documents and other files

As a rule, you can attach any file that was created with one of the 2007 Microsoft Office system programs. You can also attach log files (.log), text files (.text, .txt), and compressed .zip files.

File-naming conventions

The names of your attached files can contain any Unicode character supported by the NTFS file system used in Microsoft Windows NT (NTFS). In addition, file names must conform to these guidelines:

  • Names must not exceed 255 characters, including the file name extensions.

  • Names cannot contain the following characters: question marks (?), quotation marks ("), forward or backward slashes (/ \), opening or closing brackets (< >), asterisks (*), vertical bars or pipes (|), colons (:), or paragraph marks (¶).

Types of files that Access compresses

Access will compress your attached files unless those files are compressed natively. For example, JPEG files are compressed by the graphics program that created them, so Access does not compress them. the following table lists some supported file types and whether or not Access compresses them.

File Extension

Compressed?

Reason

.jpg, .jpeg

No

Already compressed

.gif

No

Already compressed

.png

No

Already compressed

.tif, .tiff

Yes

.exif

Yes

.bmp

Yes

.emf

Yes

.wmf

Yes

.ico

Yes

.zip

No

Already compressed

.cab

No

Already compressed

.docx

No

Already compressed (Metro file)

.xlsx

No

Already compressed (Metro file)

.xlsb

No

Already compressed (Metro file)

.pptx

No

Already compressed (Metro file)

Blocked file formats

Office Access 2007 blocks the following types of attached files. At this time, you cannot unblock any of the file types listed here.

.ade

.ins

.mda

.scr

.adp

.isp

.mdb

.sct

.app

.its

.mde

.shb

.asp

.js

.mdt

.shs

.bas

.jse

.mdw

.tmp

.bat

.ksh

.mdz

.url

.cer

.lnk

.msc

.vb

.chm

.mad

.msi

.vbe

.cmd

.maf

.msp

.vbs

.com

.mag

.mst

.vsmacros

.cpl

.mam

.ops

.vss

.crt

.maq

.pcd

.vst

.csh

.mar

.pif

.vsw

.exe

.mas

.prf

.ws

.fxp

.mat

.prg

.wsc

.hlp

.mau

.pst

.wsf

.hta

.mav

.reg

.wsh

.inf

.maw

.scf

Community Additions

ADD
Show:
© 2014 Microsoft