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

[James Barash]

Brad:

I assume you tried adding a Bound Object Frame to a form and binding it to the OLE field. If that didn't work then the object is probably a format that Access doesn't support.

I'm not sure if this will help but I've used some of Lebans' code to extract files from Access OLE fields so maybe it will work here as well.

www.lebans.com/oletodisk.htm

You'd have to save each object to disk and then try to read it back but it might do what you need.

Hope this helps.

James



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