ms-access and booleans ? - Mailing list pgsql-odbc

Hi,

I transferred a couple of tables from an Access MDB to Postgres.
Among the involved column-types are booleans.

I could dump the contend of the Access table to PG via an odbc linked table.

In  psql  I can run :
    SELECT count(*) FROM my_table WHERE some_boolean;
It shows some number as expected.

I Access I get an Error:
ODBC-Call failed.
Error: Operator doesn't exist:  boolean = integer (#7)

In the System-DSN I have
Bool as Char :   NO
True is -1 :    YES

How can have booleans that don't break my Access front-end ?


cu
    Andreas