Re: Using MS Access front-end with PG

From: Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Using MS Access front-end with PG
Date: 2007-04-04 03:03:53
Message-ID: 46131599.60805@autoledgers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Paul Lambert wrote:
> I've got an MS Access front end reporting system that has previously
> used MS SQL server which I am moving to Postgres.
>
> The front end has several hundred if not thousand inbuilt/hard-coded
> queries, most of which aren't working for the following reasons:
> 1.) Access uses double quotes ("") as text qualifiers, PG uses single
> quotes. ('')

Ignore point one in my op, it wasn't the double quotes causing the
problem and was a quick and easy fix.

Thanks,
P.

--
Paul Lambert
Database Administrator
AutoLedgers

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-04-04 03:20:07 Re: Using MS Access front-end with PG]
Previous Message Klint Gore 2007-04-04 03:02:24 Re: Using MS Access front-end with PG]