View Single Post
  #3  
Old October 11th, 2009, 11:14 PM posted to microsoft.public.access.formscoding,microsoft.public.access.tablesdbdesign
Mark Andrews[_2_]
external usenet poster
 
Posts: 600
Default A2007 - OLE vs. Attachements

Have you considered using the attachment field and bloating?
Pros and cons for each approach. A picture to a contact record is probably
the typical senerio
Microsoft envisioned for using the attachment field "as is". Not storing
tons and tons of graphics etc...
You get to see a preview of the image (for most formats). I believe they
made it better on the "amount of bloating that occurs".

I don't think you can use the attachment field to hold a link.
You can add/extract attachments via code to move things back and forth from
the filesystem to the database.

HTH
Mark

"Jay Oken" wrote in message
...
I would like to add a picture to a record but do not know the best way to
do it. From what I can see OLE gives the option to "link" to the picture
file rather than imbed the picture in the database which then bloats my
database. The "attachment" type field has a nicer interface when I put it
on a form but bloats the database. Is there a way to use the Attachment
field type but have it be a link to the picture.

Thanks,
J