Saving pictures

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
 
P

Pango

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
 
J

John Vinson

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.
 
Top