ADODB.Recordset help

[sub850]

hello, i was wondering if it was possible to set a field to a specific Word Document from VB using an ADODB recordset. it can be done "manually" using just Access, but i am creating an app that needs to do this behind the scenes.

thanks in advance for any help,
PJ

[Static]

you should be able to do just about anything in VB that you can in access.

Record a macro of it...then post the macro code.

[sub850]

is it possible to record a macro in access though like in word? i can't seem to figure it out. thanks, PJ

[Joe_B]

So are you just trying to embed a Word document into a database?

If you are, then you could read the word document into a Stream Object and then write it to the field in the record desired through a recordset and update the recordset.

For example:

dim objStream as adodb.stream
dim recset as adodb.recordset

objstream.open
objstream.type = adtypebinary
objStream.LoadFromFile "c:\somefilename.doc"

recset.fields("somefield") = objstream.read
recset.update

[sub850]

where is the stream function? i do not see it when i place the period after ADODB.

thanks, PJ

[Joe_B]

You would need to download the ADO 2.5 library(msado15.olb)

[spetnik]

Originally posted by sub850
where is the stream function? i do not see it when i place the period after ADODB.

thanks, PJ

Stream is an Object, not a Funtion