How to create a Long Binary Data field?

[UnhandledException]

Yes, I know, don't store binary data in the database as it becomes bloated....blah blah blah...

Based on the numerous searches I keep reading that binary data (images) should be stored as Long Binary Data in Access as opposed to an OLE Object, but I don't see how to actually create a Long Binary Data field.

Access 2007 is being used and some of the articles read predate the 2007 version.

Would someone be so kind and elaborate on this Long Binary Data field I keep reading about and how to create it?

 

[Banana]

IINM, VarBinary (there's a VarBinary, too, which I think is what you want because Long Binary = OLE Object), is not available via UI but you can create one via DDL.

 

[DCrake]

Here is a Demo that embeds objects as long binary data into an Access database. It uses File to Blob and Blob to File format, it also has other interesting features that may or may not be useful to you.

David