| | |
|
|
|
Saving pictures |
|---|
| message from Brad Allison on 11 May 2004 |
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
|
| =?Utf-8?B?UGFuZ28=?= replied to Brad Allison on 12 May 2004 |
Yes it is. This wil allow you to either embed or link the pictures to your app.
Pango
|
| John Vinson replied to Brad Allison on 12 May 2004 |
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.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
|
Archived message: Saving pictures (Microsoft Access Forms)
