VB Access GIF picture

[wekkew]

hello

Is there anyway I can add a *.gif picture to a database (held in OLE Object field) and then view that *.gif picture in VB form (OLE, picture box, image, anything really!)

I can do the above with *.bmp but desp. need gif due to file sizes. At push would be prepare to use other formats (but ideally not - as all pictures will have to be converted) just need to get away from huge files size of bitmaps.

Kate

 

[irfcgi]

Hello Kate

If I understood correctly, there should be no problem placing OLE feild in Access 2K to hold a .gif and displaying the same in OLE control on VB form using DataSource and DateFeild properties. At least I have done it with VB 6.

Anyhow, there could be a contingency plan for your particular case: don't use OLE controls at all because BLOBS may cost you more, rather use a simple text field to hold a reference of the .gif stored on your HDD and then use the same filename to LOADPICTURE() inside picture box at runtime in your VB app.

Regards

Irfan Ahmed.