how do i read/open a file stored in a long binary format in a rec.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

access query - 26 Feb 2005 06:21 GMT

i have a file stored as long binary field in the recordset. i want to open
that file and should be able to edit it at click of a button. how would i do
it????
i think i can use appendchunk/get chunk method ,but i donno how to use it??

Reply to this Message

John Nurick - 26 Feb 2005 07:59 GMT

What you need to do depends on whether the field contains an OLE package
containing the file (which is what happens if you drag a file's icon
onto an Access OLE field or BoundObjectFrame control), or whether the
field simply contains the binary contents of the file.

If the former, write code that drives a form and an ObjectFrame. If the
latter, Stephan Lebans recently posted this answer:

>There's code in my SaveRestoreRelationShipsWIndow MDB that shows how to
>Get Long Binary data directly from a Recordset.
[quoted text clipped - 6 lines]
>http://www.lebans.com
>Access Code, Tips and Tricks

>i have a file stored as long binary field in the recordset. i want to open
>that file and should be able to edit it at click of a button. how would i do
>it????
>i think i can use appendchunk/get chunk method ,but i donno how to use it??

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message