Insert picture into access database

The question is really simple...
How can I insert a picture into a database. What I want is like:

Item:
ItemID (autonum)
Text (memo)

Picture:
PictureID (autonum)
ItemID (referencing)
Picture (...)

Now I want to have a form where I can enter some details about the pictures and maybe have some kind of slide show where I can see the already inserted pictures.

But I just cannot get it to insert a picture.
Could anyone help me with this? I think I need to have something like VBA to insert it.


Thanks
G00fyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Arthur_WoodCommented:
in general it is NOT a good idea to insert the actual picture file itself into the table - this will rapidly lead to serious database BLOAT.  YOu would be much smarter to inter the PATH to the picture file (as a string) into the table (a Text field), and then load the pocture using the LoadPicture method, passing the filepath from ther table.

You store the actual picture file on disk, and store the file path in the table.  That way youcan easily update the picture, without having to change the database at all.

If you need help with this, just ask.

AW
thenelsonCommented:
G00fyAuthor Commented:
Arthur: I know that, and I don't want... I don't care about space. But I care about having multiple files... It's just that when I download pictures from the internet, I want to have them saved in the database & then I delete them. Case closed ;).

I only need to be concerned about the database, further nothing.


thenelson: Same reaction for you, it's very nice, but I really really want to insert the pictures into the database.
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

thenelsonCommented:
Well then, you want:
http://www.nosuffering.com/Nelson/ImageDemo.zip
It's designed to save small icons in the database but you can resize the bound object frame.
To enter the picture, view it in an OLE capable image viewer like the Kodak Imaging for Windows that comes with Office 2000.  Copy and paste the image into the bound frame.
G00fyAuthor Commented:
This is more like it, but then you need OLE-thingies... And I just want something like saving the bits in the database and getting them out later on...

Because I already looked into the OLE-thingies and it's too bad, but you need (as you said) an OLE capable image viewer, which I have not (checked for imaging on my computer, but I only have "Windows Picture and Fax Viewer").
thenelsonCommented:
Kodak Imaging can be downloaded from www.eastmansoftwarek.com

I am afraid that you are stuck with one or the other.  As far as I know, Access does not have the ability to save images in a table.  Text pointing to an image, an OLE object, yes.  An image, no.

I have seen picture cataloguing software on shareware sites like tucows.  Some I remember are free.  That's the only other suggestion I know of.

Hope that helps.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
G00fyAuthor Commented:
:'( Thanks for the efforts!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.