blobs-binary data

I am having trouble with my access database, can anyone tell me how to get binary data into my fields?

if you just want to be able to type the data in as 1's and 0's simply make it a text field.

I assume that the post above was a joke, for reference blobs are binary large objects.
I'm not sure if access supports them but MySQL sure does, perhaps you would be better off going with that?

It is possible to get binary data into Access, although it is a bit of a pain. I did this "once apon a time", when I actually worked with Access, but that was about 4 years ago.

As I recall, the datatype you have to choose for your column is "OLE", or "OLE Embedded", or something like that. Now, I won't guarantee that this works for any type of binary data, but it worked for Office documents using a binary format, so I think there should be a way to accomplish this. It will probably require some tortuous scripting, though.

If you are really desperate to accomplish this, I will try to drag up my old files and find that Access database I did. I actually had it worked out so that you could paste data from a Word document into an access form field, and it would preserve formatting, showing up as a thumnbail of the Word doc. If the user double-clicked, the document would open up into a full-page Word window. Slick, huh ?

I should also mention that binary data is still just data, and that there are methods for escaping binary data into text, so that you could conceivably do this and just insert it into a Memo column. (I'm thinking this might be useful if you are connecting to Access from PHP, or something like that).

Exactly what are you trying to accomplish, and in what programming environment?

if you are working in windows and using MS Access and you use ADO then try this link :

http://www.atalasoft.com/Components...s/Database.html