Saving DB binary field data into file 
Author Message
 Saving DB binary field data into file

Hi all experts,

I have a problem dealing with objects. I have an Access database with a
binary field contains photo, voice, Real audio.... binary files. I would
like to know how can I do it in VB leting user choose file from this
field (with preview function) and save the file into her local hard disk
?

Thank you very much!

William



Mon, 22 Apr 2002 03:00:00 GMT  
 Saving DB binary field data into file
Von den Thu, 04 Nov 1999 18:20:20 +0800, William Chan

Quote:
> Hi all experts,

> I have a problem dealing with objects. I have an Access database with a
> binary field contains photo, voice, Real audio.... binary files. I would
> like to know how can I do it in VB leting user choose file from this
> field (with preview function) and save the file into her local hard disk

1.  Open the file as Binary
2.  Read the entire file contents into a string variable
3.  Set the recordset field variable equal to the string
4.  Update the recordset.

---------------------------------------------------------------

:)             aka Jack Voltz            :)  Web: www.ovnet.com/~voltz
:)      M  A  R  A  N  A  T  H  A  !     :)  Prolife: ./prolife.htm
:)    S i e m p r e  P o r   V i d a !   :)  Music: ./music.htm
;)         Pour la Vie, toujours !       :)  Y2K: ./y2klinks.htm
;)           Sempre per la Vita!         :)  
;)             Semper Pro Vita!          :)  
;)    A L W A Y S   P R O   L I F E !    :)  



Mon, 22 Apr 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Serialising Objects to save in Binary field in Jet DB

2. Write ADO Field containing binary data (files) to the file system

3. Saving A Binary File Into an OLE Object Field

4. Saving A Binary File Into An OLE Object Field

5. How save JPG file in SQL Server image or binary field

6. Saving a binary file to a database field

7. Saving Binary files on the Client to the Image data type in SQL Server

8. problem saving binary data into a file

9. Storing binary file data in a Jet memo field

10. Losing Calculated Form Field Data after File Save

11. Binary fields MS-Access DB using ODBC

12. Storing images in binary fields in an Access DB

 

 
Powered by phpBB® Forum Software