Page 1 of 1

How to Store Images in MDB Table using FWH ?

Posted: Sat Apr 08, 2006 3:06 am
by RAMESHBABU
Hi

Can anybody guide me: How to store images in MS Access Table
Fields like the way we store images in .FPT file using FWH ?

Thanks in advance

- Ramesh Babu P

Re: How to Store Images in MDB Table using FWH ?

Posted: Tue Apr 11, 2006 1:34 pm
by ask
RAMESHBABU wrote:Hi

Can anybody guide me: How to store images in MS Access Table
Fields like the way we store images in .FPT file using FWH ?

Thanks in advance

- Ramesh Babu P
As i know, the problem is that you can do this only with DAO and not ADO.With ADO you can store large amount of array byte inside an OLE field but access will not recognize it as Image.

Regards
A.S.K

Posted: Tue Apr 11, 2006 3:33 pm
by dbzap
( sorry for my english )
I use a neanderthal tecnique:
1. read the bitmap ( or other format )
2. transform to text with base64
3. in base64, is text; simple to store in any field of varchar o variable length.

For display, the process is the same but in inverse order.

I hope serve to you
Bye.

Posted: Wed Apr 12, 2006 1:52 am
by RAMESHBABU
Hi dbzap
1. read the bitmap ( or other format )
2. transform to text with base64
3. in base64, is text; simple to store in any field of varchar o variable length.

For display, the process is the same but in inverse order.
Can I get a small working sample please.

Thanks to ask and dbzap

- Ramesh Babu P

Posted: Wed Apr 12, 2006 10:11 am
by ask
dbzap wrote:( sorry for my english )
I use a neanderthal tecnique:
1. read the bitmap ( or other format )
2. transform to text with base64
3. in base64, is text; simple to store in any field of varchar o variable length.

For display, the process is the same but in inverse order.

I hope serve to you
Bye.
This is the know way BUT you can not see the image from ACCESS.If this does not bother you then you don't have any problems.

Regards
A.S.K