IonicWind Software
February 04, 2012, 11:13:42 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: IWBasic ver 2.0 released!
 
   Home   Help Login Register  
Pages: [1]
  Print  
Author Topic: MSAccess IMAGE field  (Read 1607 times)
0 Members and 1 Guest are viewing this topic.
LarryMc
Administrator
Hero Member
*****
Online Online

Posts: 3665


'All I like is finishing'


« on: June 01, 2009, 05:39:34 AM »

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
Logged

Larry McCaughn Smiley
Author of IWB+, Custom Button Designer, Custom Chart Designer, and Snippet Manager
LarryMc
Administrator
Hero Member
*****
Online Online

Posts: 3665


'All I like is finishing'


« Reply #1 on: June 01, 2009, 08:02:36 AM »

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
Logged

Larry McCaughn Smiley
Author of IWB+, Custom Button Designer, Custom Chart Designer, and Snippet Manager
JoaoAfonso
Paid Subscriber
Full Member
*****
Offline Offline

Posts: 237


WWW
« Reply #2 on: January 03, 2010, 06:29:50 PM »

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.
Logged

João Afonso
Viriato
-----------------
Iberia MUD
www.iberiamud.com
iberiamud.com:5900
JoaoAfonso
Paid Subscriber
Full Member
*****
Offline Offline

Posts: 237


WWW
« Reply #3 on: January 03, 2010, 06:32:16 PM »

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.
Logged

João Afonso
Viriato
-----------------
Iberia MUD
www.iberiamud.com
iberiamud.com:5900
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.15 | SMF © 2011, Simple Machines Valid XHTML 1.0! Valid CSS!


Google visited last this page January 12, 2012, 11:21:12 PM