Postgres Pro
Downloads
Home   >   mailing lists

Re: Using MS Access front-end with PG - Mailing list pgsql-general

From Paul Lambert
Subject Re: Using MS Access front-end with PG
Date
Msg-id 46131599.60805@autoledgers.com.au
Whole thread Raw
In response to Using MS Access front-end with PG  (Paul Lambert <paul.lambert@autoledgers.com.au>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Paul Lambert
Date:
Subject: Re: Using MS Access front-end with PG]
Next
From: Tom Lane
Date:
Subject: Re: Using MS Access front-end with PG]