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

Bill Benson bensonforums at gmail.com
Mon May 4 16:59:08 CDT 2015


Someone showed me an SQL editor that they pasted code into and it showed up
much better than in the Access SQL window. I wish I knew what that was, I
am sure it was a common editor many people use. Doesn't prevent Access from
messing with it afterward of course.

On Mon, May 4, 2015 at 7:33 AM, Jim Lawrence <accessd at shaw.ca> wrote:

> Ouch.
>
> Jim
>
> ----- Original Message -----
> From: "Mark Simms" <marksimms at verizon.net>
> To: "Access Developers discussion and problem solving" <
> accessd at databaseadvisors.com>
> Sent: Sunday, May 3, 2015 6:25:11 PM
> Subject: Re: [AccessD] How To Display an Image from a Pervasive Database
> table Via Access 2007
>
> 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
>
>
> --
> 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