How to save a picturebox in a .mbd file?

[DORI]

Hi all,
I posted the same question in access.gettingstarted forum but no answer, I
think I may have posted in the wrong place so I am trying this forum.
I have a VB6 form which uses a .mdb file as its database to save some
textual data. The users want to be able to draw some graphic shapes in a
picturebox on the VB form and save the drawing with the entered textual data
in order to be reviewed from another computer at workplace.
Is it possible to save the content of a picturebox in Access in order to
keep both textual data and graphics in one database?
Thank you very much for any comments in advance.
DORI

 

[John W. Vinson]

Is it possible to save the content of a picturebox in Access in order to
keep both textual data and graphics in one database?

Possible... but up until A2007, probably not a good idea! Access can be VERY
inefficient at storing image data; the database will bloat very rapidly. See
the links at

http://www.mvps.org/access/forms/frm0030.htm

for an explanation and some possible alternative approaches - basically, you
can save the graphic image in an external file, and save the *path and
filename* to the image in a text or hyperlink field in the table.

John W. Vinson [MVP]