July 01, 2022, 02:10:16 AM

News:

Own IWBasic 2.x ? -----> Get your free upgrade to 3.x now.........


MSAccess IMAGE field

Started by LarryMc, June 01, 2009, 03:39:34 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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
Larry McCaughn :)
Author of IWB+, Custom Button Designer library, Custom Chart Designer library, Snippet Manager, IWGrid control library, LM_Image control library

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
LarryMc
Larry McCaughn :)
Author of IWB+, Custom Button Designer library, Custom Chart Designer library, Snippet Manager, IWGrid control library, LM_Image control library

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.
JoÃÆ'ƒÂÃ,£o Afonso
Viriato
-----------------
Iberia MUD
www.iberiamud.com
iberiamud.com:5900

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.
JoÃÆ'ƒÂÃ,£o Afonso
Viriato
-----------------
Iberia MUD
www.iberiamud.com
iberiamud.com:5900