■ jwFreeNote_02

Resolved Question Show me another ≫ How to store binary data in ms access? 2 years ago Report Abuse by Einstein Member since: 25 June 2007 Total points: 5552 (Level 5) Add to My Contacts Block User Best Answer - Chosen by Voters You can store large data objects (such as sound, video, or graphic data) in a field with the OLE Object data type in a Microsoft Access table. Some large binary data objects cannot be represented, however, if they do not have an OLE server that understands the data being stored. You can also store copies of executable program files or other non-OLE data in a Microsoft Access table. This type of data is referred to as a binary large object bitmap (BLOB). Check out the full implementation of the function to store binary data into an Access database at: http://support.microsoft.com/kb/103257 '*************************************... OVERVIEW FUNCTION: WriteBLOB() PURPOSE: Writes BLOB information stored in the specified table and field ' to the specified disk file. PREREQUISITES: The specified table with the OLE object field containing the' binary data must be opened in Visual Basic code (Access Basic code in Microsoft Access 2.0 or earlier) and the correct record navigated to prior to calling the WriteBLOB() function. ARGUMENTS: 1) T - The table object, T, containing the binary information. 2) sField - The OLE object field in table T containing the binary information to write. 3) Destination - The path and filename to write the binary information to. RETURN: The number of bytes written to the destination file. '*************************************... PSEUDO-CODE Function WriteBLOB(T As Recordset, sField As String, _ Destination As String) ' Get the size of the field. ' Calculate number of blocks to write and leftover bytes. ' Remove any existing destination file. ' Open the destination file. ' Write the blocks of data to the output file. ' Within a loop - read a chunk, and write it to output file. ' Terminate function End Function Source(s): http://support.microsoft.com/kb/103257 If you are working with ASP and Access, then read this: http://www.stardeveloper.com/articles/03... 2 years ago 100% 1 Vote Report Abuse Is this what you are searching for? Rating: Good Answer Rating: Bad Answer 0 stars - mark this as Interesting! Who found this interesting? Be the first person to mark this question as interesting! Email Comment (0)