MSAccess IMAGE field

[LarryMc]

Using the EB Database functions I can create an Access table with a field of type IMAGE.

That will, according to documentation, let me store up to 1Gig of binary data in a record.

Now all I need someone to do is tell me how to get the binary data in and get it back out.

Larry

[LarryMc]

This is a VB article explaining how to do it.

I don't know how to implement/convert the ADO parts and it appears to be using a server.
I just want to be able to do it on the local computer.

http://support.microsoft.com/kb/194975

Larry

[JoaoAfonso]

I am having the same problem.

Need to surf google again, because I've read that OLE objects put in an MS Access db can be write and read normally, but there are some information at the begining of the field that does not belong to images. That is why it doesn't work...

Anyway, my question is:
- which is the difference of inserting/reading data from a DB using normal SQL commands, or ADO DB connection/recordsets?

Thanks in advance.

[JoaoAfonso]

Btw, one must be carefull when adding pictures to a DB, because it will increase DB the size of the picture. 100 records each with a 1Mb picture size, will make it huge...

Reading in other foruns, and I believe that also here in EB forum, the best way to workaround is save in a field of database the path where picture is.