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

See if Stephan Lebans has something you could use effectively.

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

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

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?

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

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?

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

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

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

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"