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??

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.
>A search on GoogleGroups for my name and PUT or GET will show you how to
>Put or Get data from a long Binary field or a file on disk.
>--
>
>HTH
>Stephen Lebans
>http://www.lebans.com
>Access Code, Tips and Tricks




On Fri, 25 Feb 2005 22:21:02 -0800, access query <access
(E-Mail Removed)> wrote:

>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.