Saving pictures

  • Thread starter Thread starter Brad Allison
  • Start date Start date
B

Brad Allison

I am using a small Access database as the back end of a VB .NET program. I
am not a newbie to Access, but I have never had the need to store pictures
until now. I have a field in a Master table named "Picture" and I have set
the Date Type as OLE Object. I know that this might be the wrong newsgroup
to post this to, but I was wondering if this is the correct data type to
handle pictures.

Thanks for the information.

Brad
 
Yes it is. This wil allow you to either embed or link the pictures to your app.
Pango

----- Brad Allison wrote: -----

I am using a small Access database as the back end of a VB .NET program. I
am not a newbie to Access, but I have never had the need to store pictures
until now. I have a field in a Master table named "Picture" and I have set
the Date Type as OLE Object. I know that this might be the wrong newsgroup
to post this to, but I was wondering if this is the correct data type to
handle pictures.

Thanks for the information.

Brad
 
I am using a small Access database as the back end of a VB .NET program. I
am not a newbie to Access, but I have never had the need to store pictures
until now. I have a field in a Master table named "Picture" and I have set
the Date Type as OLE Object. I know that this might be the wrong newsgroup
to post this to, but I was wondering if this is the correct data type to
handle pictures.
Click to expand...

It will work... BUT!

It will very rapidly cease to be a small Access database, and will
become a seriously bloated one. Access is *very* inefficient at
storing picture data.

Consider using the OLE Object but storing the picture as a "BLOB"
without informing Access that it's picutre data. There's quite a few
posts in this newsgroup about how to handle pictures - try a Google
search and follow up some of the references.
 
Back
Top