user function in ODBC database

[Bruno Castel]

Hi,
I have a Postgres database connected with ODBC to Access2003.
To avoid annoying issues with bool and integer, I have created a user
function in my Postgres database: booltoint.

I have created a MS Access request as follows:
SELECT DISTINCTROW INDIVIDU.CIV
FROM INDIVIDU
WHERE (booltoint(INDIVIDU.CIRC)=1);

But MSAccess complains that booltoint is unknows.
How to specify to MS Access to ignore this function and send as it to
Postgres database ?
Thanks,

 

[Jeff Boyce]

Bruno

Have you looked into "pass-through queries"?

 

[Bruno Castel]

Bruno

Have you looked into "pass-through queries"?

OK,
that is the solution,
thanks a lot