Article ID: 205635 - View products that this article applies to.
This article was previously published under Q205635
In Microsoft Access, OLE Object fields can store data such as Microsoft Word or Microsoft Excel documents, pictures, sound, and other types of binary data that are created in other programs. This article provides the Visual Basic code that uses an OLE control and the CreateEmbed method to store a bitmap file in an Access OLE Object field.
The advantage of using this technique is that the data is stored in the Access OLE Object format. Thus, a user who opens the database in Access and double-clicks on the item will find that the appropriate container for the data is automatically started. If you place the data into a field without using of the below-mentioned method, it is stored as "Long Binary" data in Access, and the appropriate container for the data is not started when a user double-clicks the item in Access.
The following example demonstrates how a bitmap file is stored in the OLE Object field of an Access table using Visual Basic.
Article ID: 205635 - Last Review: July 13, 2004 - Revision: 1.2
Contact us for more help
Connect with Answer Desk for expert help.