Storing OLE Images to files

[wbkayani]

Hi Guys,
I am .Net programmer, not using MS Access regularly. Currently I am working on a project where I have to develop a website for my client. This client is already using an MS Access database where he has thousands of records with their photos saved in OLE OBJECT field as embedded pictures. User is simply pasting pictures in picture box and system is storing pictures as embedded pics and showing "Picture" when you see that table in datasheet mode. This Picture format is not readable from VB.Net and I know as this is very poor database design.

My Question Iis: Is there any way to read these photos in MS Access from picture box or from the table directly and store those pictures in some folder using their IDs as name so I can read images from file folder and this will decrease huge amoount of database size, such as every record have IDs 1,2,3......xx.

I can write the code to store images from VB.Net to MS Access and then can read those images back easily. But when I store images from VB.Net, I don't paste those images in the picture box, I just select the picture by browing the folder and saving it to database as Long Binary Data, which is easily readable from VB.Net code.

Any help will be much appreciated.

Thanks

[RuralGuy]

See if Stephan Lebans has something you could use effectively.

[wbkayani]

It worked fine in access!

But I am usng VB.Net to import those photos form MS Access Database. That code works only from inside the VBA. Is there any possibility to redesign this utility in VB.Net.

Thanks

[RuralGuy]

I took a look at it and it is a stand alone application that will open another db and save all of the OLE objects to disk if that is what you want. Wouldn't that work for you on a one time basis?

[wbkayani]

I have VB.Net code and want to convert images living inside the vb. If thee is a way which I can run An Access code from inside the VB.Net code then that will be good.

[RuralGuy]

I have VB.Net code and want to convert images living inside the vb. If thee is a way which I can run An Access code from inside the VB.Net code then that will be good.

Probably, but I have no idea how. I know nothing about VB.Net. Will this be a continuing process or a one shot get it done thing?

[wbkayani]

This is an estate agent company, want t upload images on the web on daily basis. Anyway; thanks for your help and I will try to use the code you reffered.

Thanks and Regards

[RuralGuy]

Good luck. Sorry I could not be of more help.