Binary datatype

[huBelial]

I'm trying to create a table with a binary datatype column in Access 2007 to store jpeg images. Does Access not offer binary datatype? I tried using OLE but it did not work out well. When I tried using OLE to store images, I can't seem to retrieve the images through a program using VB.NET.

I'm following this tutorial on how to retrieve images from access but the tutorial requires a binary datatype column.

http://www.dreamincode.net/code/snippet2846.htm

[kennejd]

If you're going to write your front-end in VB.NET, you may have better luck using Sql Server....that's where you'll find binary type fields. But the better method would probably be to store the path to the image....and display the image based on the path. Storing images in databases is not a great idea, in my opinion.