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