VB code: saving BMP images stored in OLE data type in MS access to JPG format in a folder
Posted on 2009-05-02
I have microsoft access table containing BMP images stored in OLE data type . I wish to write a visual basic code to save the images in JPG format in a particular folder. Each JPG file should be named by unique ID that identifies each record in the table and suffixed by a letter that describes image category. For example, the MS access table 4 fields. Application number that uniquely identifies a record and 3 OLE datatype fields each for photograph, signature, and thumb impression. First record has application number as 1001, and second as 1002 and so on. The 3 JPG images for each record in a folder should be saved and named in such a way that photograph should be named as 1001p.jpg, signature as 1001s.jpg and thumb impression as 1001t.jpg. The JPG Images for second record should be saved as 1002p.jgp, 1002s.jpg and 1002t.jpg. So on for all the records in the table. The idea is to upload the entire folder to web and write asp code for displaying images on the web. I wish to have the code in visual basic for access or VB6 to run on my local system.