convert Binary Stream to BLOB?

[roger]

(repost from ADO DAO group where no one replied)

using MSA2k7
I have 2 subs. that I rewrote from web example code.

sub1 fixes a certain type of broken files I have by open reading it as an
ADO Binary stream, editing the stream and writing it back to the HD.

later sub 2. reads in that file as a BLOB(?) and uses it for something else.

can I just convert the Binary stream into a BLOB directly.

Is it too much to hope for a cBLOB() Method?

TIA

 

[Douglas J. Steele]

The code in http://support.microsoft.com/kb/258038 should work in Access.

 

[Sylvain Lafontaine]

The following reference says that you can directly convert a stream to a
blob by resetting its Position to 0 and using the ReadText method to
directly load the blob field:

http://www.betav.com/Files/Content/Whitepapers/Using the ADO Stream Object to Manage BLOBs.htm

For the rest of your post, I don't know as I have no idea of what is the
cBlob method. If you are using a recordset opened against Oracle or another
type of specialised recordset, you should give these kind of details.