[AccessD] How To Display an Image from a Pervasive Database table Via Access 2007

[Jim Dettman]

<<
I wonder if I need to add some additional software to view images via Access
2007 reports or forms.
>>

 That would be correct.  You need something installed on your system and
registered for the extension that the OLE object is in.  Ie. MS Paint can
handle .jpg and can be registered as an OLE server.

Jim.
-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Brad Marks
Sent: Sunday, May 03, 2015 10:34 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How To Display an Image from a Pervasive Database
table Via Access 2007

Jim, 

Thanks for your input on this problem.  I agree with you.  If the pictures
were stored in their own folder, I would not be running into this problem.

The catch is that I am trying to pull pictures that are stored in a database
that is part of a purchased accounting package.  When this accounting system
was installed, there was not an option as to where the pictures are stored.
We had to use the system as delivered.  Therefore the pictures are stored in
the database.

I have many queries that pull data via ODBC from this database.  These all
work nicely.  When I add the image field to one of these queries, I see
"OLE" when I run the query.  However, when I try to view the picture with an
Access report or form, nothing is shown.

I wonder if I need to add some additional software to view images via Access
2007 reports or forms.

Brad
 
   

________________________________________
From: AccessD <accessd-bounces at databaseadvisors.com> on behalf of Jim
Lawrence <accessd at shaw.ca>
Sent: Sunday, May 3, 2015 5:25 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How To Display an Image from a Pervasive Database
table Via Access 2007

One comment Brad. Things may have changed since a decade ago but I have
found that improvement in MS Access tend not to progress too rapidly. My one
recommendation is to not embed pictures within the application just call any
images from their own directory as necessary.

Jim

----- Original Message -----
From: "Brad Marks" <bradm at blackforestltd.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Thursday, April 30, 2015 11:48:04 AM
Subject: [AccessD] How To Display an Image from a Pervasive Database table
Via Access 2007

All,

We have a purchased accounting package called Sage Business Works.

Pictures of products are stored in the Business Works database (Pervasive).

>From the product documentation I see a field named "Image".

When I connect to the Parts table, with Access, I can run a query which
shows the Image field as "OLE object".  All of the other fields are shown
(text fields, numeric fields)

I have never worked with images before.  I would like to be able to display
these images with an Access form or report.

I have done a number of experiments, but I have not been able to see the
images with either an Access form or report.

I must be missing something.

Any help would be appreciated.

Thanks,

Brad

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com