No "Attachment" option in dialog box scroll down Data Type

[jarhead382]

I want to add an attachment (JPG photo) field to a table, but there is no
"Attachment" option in scroll down of Datasheet/Data Type.

 

[Fred]

I noticed that nobody answered. It would be in the eye of the beholder what
an "attachment field" exactly would be. Obviously it would record linkage to
a file, but that doesn't take a field type. For most people this to a .jpg
would mean the ability to view and print the picture.

For Access 2003 and older, the OLE field isn't viable for this and so the
choice is simple. Store the path and file name of the picture in a text
field. Use code to display the image in forms and reports. Previous posts in
this forum covered how to do that.

For 2007 (which I own but don't use) I heard that the OLE field is viable
which give you a second choice.

Hope this helps a little.

 

[Jeff Conrad [MSFT]]

If you're using Access 2007, see this page on my site:
http://accessjunkie.com/faq_51.aspx

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com