How to handle image?

[clara]

Hi all,

I am in a case that a image and some texts should be best saved as a record
into a
table and can be retrieved back in a win form. I am wondering how to do the
image operation with database both in Access and SQL Server2005.
Could you tell a outline?

Clara

 

[Fred]

Being a newbie in that area I went through the long process of learning this
(including by mistakes) about 3-5 months ago, and you'll see it if you search
old posts (maybe under Access programming)

But briefly, you don't put images IN the table. You put their file name and
path into a character (not hyperlink) field. Then when you want to use them,
(which is going to be either a form or a report) you use code or properties
to display the correct image.

Fred

 

[Daniel Pineault]

Clara,

if your using Access 2003 or earlier, you should not actually embed/save the
images in the database as it will lead to database bloating very rapidly.
Instead you save the image in a specific directory and save on the the path &
filenames in your database.

If your using Access 2007 they made changes that actually make it acceptable
to save the images directly in the database. So then either approach will
work.

 

[clara]

Hi Daniel,

Could you tell me how to write the INSERT or SELECT statement that involves
image fields?

Clara

thank you so much for your help

 

[Fred]

Unless you have 2007 an are using that alternative to actually embed the
images, then what you are putting into the field is merely text (the path +
file name) and you'd load it as you'd load any text field