VB and Access OLE

[JohnBoy2005]

I have an Access database with a table that contains an OLE Object field. This field contains pictures, jpg's, gif's and bmp's

I have a routine in VB that adds the picture to the OLE field, but I want to know how I can bring the OLE field data into an array, for example

for x = 1 to rstTemp.RecordCount
strName(x) = rstTemp("Name")
strAge(x) = rstTemp("Age")
objPicture(x) = rstTemp("Object") ' this is in theory, I know it isn't as simple as that.
next x

Any help will be much appreciated.

Cheers

John

 

[tonymce]

why do you kneed to put it into an array?
these are objects and it will fill the memory so fast it is unbeliveable type putting a pointer into an array then use the pointer to referance to the ole recordset then do the modification to it in that state