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

Mark Simms marksimms at verizon.net
Sun May 3 20:25:11 CDT 2015


Re: " improvement in MS Access tend not to progress too rapidly."
This may be the understatement of the century.
Examples:
1) SQL in queries don't retain their original format.
Any large query quickly becomes a indecipherable string of letters.
2) no comments permitted in the SQL of a query.
Why did I do this GROUP BY again ?

This has to be intentional.

> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> Of Jim Lawrence
> Sent: Sunday, May 03, 2015 6:26 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




More information about the AccessD mailing list