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

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.

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.

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

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

"jarhead382" wrote in message:
news
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.