(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

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"roger" <(E-Mail Removed)> wrote in message
news:1790E1DD-FE34-4965-B6D6-(E-Mail Removed)...
> (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

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/W...ge%20BLOBs.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.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"roger" <(E-Mail Removed)> wrote in message
news:1790E1DD-FE34-4965-B6D6-(E-Mail Removed)...
> (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