Storing images in a Access 2000 Database with ADO to Access the Database

[Ben]

Hello people,
I have abit of a problem I hope you can help me with,

I want to store images in an Access 2000 database so that I can send the
database to anouther computer and open it using ADO and retrieve the image
to print it. I have tried alsorts of methods but when I try to open the
image on the new computer it gives me an error saying that the image I am
trying to open does not exist (which it wouldnt).

Any help would be great

Cheers
Ben

[Bob Rouse]

You will need to store the image as a BLOB. Visual Basic Programmers Journal
just did an article on this very subject. Check the Feb 2001 issue. The code
listing locator code is "VB0102GS". IF you are a DevX Premier club member,
you can read the article on-line by using locator code "VB0102GS_T".

"Ben" <Ben@intec-systems.co.uk> wrote:
>
>Hello people,
> I have abit of a problem I hope you can help me with,
>
>I want to store images in an Access 2000 database so that I can send the
>database to anouther computer and open it using ADO and retrieve the image
>to print it. I have tried alsorts of methods but when I try to open the
>image on the new computer it gives me an error saying that the image I am
>trying to open does not exist (which it wouldnt).
>
>Any help would be great
>
>Cheers
>Ben
>

[Andrew Grillage]

http://www.concresco.com/code.htm#pictures

Andrew Grillage


"Ben" <Ben@intec-systems.co.uk> wrote in message
news:3a9f949b$1@news.devx.com...
>
> Hello people,
> I have abit of a problem I hope you can help me with,
>
> I want to store images in an Access 2000 database so that I can send the
> database to anouther computer and open it using ADO and retrieve the image
> to print it. I have tried alsorts of methods but when I try to open the
> image on the new computer it gives me an error saying that the image I am
> trying to open does not exist (which it wouldnt).
>
> Any help would be great
>
> Cheers
> Ben
>