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