Adding Images to Database

[kdog436089]

Hello Everyone,

I was curious if there is a way to embed images into a database, so that if I emailed it to someone, the images would still be able to open. I tried using a table and adding attachments, but that doesn't seem to work very well. Any other suggestions?

Thanks

 

[pr2-eugin]

I would use Hyperlinks. This way the DB size would be still in limit and also more faster to access.

 

[kdog436089]

Thank you for the quick response.

If I used hyperlinks, how would I set that up for the end user? Wouldn't it just create a link to the file location on my computer?

Thanks.

 

[pr2-eugin]

I have answered another user for Picture related stuff earlier. Check out the whole thread, particularly this post : http://www.access-programmers.co.uk/forums/showthread.php?p=1280590#post1280590

 

[kdog436089]

I took a look at the combo box that you spoke about, but what i'm looking for is just when the user would open the form, the picture would already be there and no clicking or selection is required. Almost like just adding "insert image" on a local database.

I'm not sure if what I am asking makes sense.

 

[dinoc]

If you are using access 2010 or up (possibly 2007 also), then there is now a field type called Attachment that you can use in a table. It allows you to upload attachements of just about any type.

When you add the field to a form you get a little paper clip (or double click) in a text box that gives an upload, delete and open options for the attachment. And I believe you can add more than one attachment.

 

[pr2-eugin]

I'm not sure if what I am asking makes sense.

I understand what you want, what I am saying is, that is how it should be done. You need to do some work on it. Instead of using the ComboBox you will have a table (or) if you already have one then all you have to do is simply add the link there. and for every record (so you use Form Current event) you use the "unbound" picture frame to have its path to the location in the table.