Picture storage

[FrancisC]

I am writing an aplication that will need to retrieve data and images from a database. I am planning on using an Access database but not sure how to store and retrieve the images.

Does anyone know how to do this ? What field type can I use ?

Thanks !

[mlewis]

use a Memo field

in code use the AppendChunk method of the Field object.

use GetChunk to load the picture out.

use temp files as a buffer.

Ie:

Get field from db, save to file
load pic from file
delete file