I'm trying to pull records on a Macola table linked to Access. If
enter a value in the criteria field of the query form, the quer
executes okay. If I change the criteria to a parameter, ala, [ente
ship via code], I get the ODBC... call failed error. The data ite
is a 3 character text field. I've tried to us the parameter AFTE
trimming the table field. no luck

Any helpful hints? :

On Wed, 18 May 2005 02:06:37 -0500, TheKval@nwbedding-dot-com.no-spam.invalid
(TheKval) wrote:
[color=blue]
>I'm trying to pull records on a Macola table linked to Access. If I
>enter a value in the criteria field of the query form, the query
>executes okay. If I change the criteria to a parameter, ala, [enter
>ship via code], I get the ODBC... call failed error. The data item
>is a 3 character text field. I've tried to us the parameter AFTER
>trimming the table field. no luck.
>
>Any helpful hints? :([/color]

It sounds like it might be a compatability issue with the ODBC driver. If
that's the case, there may not be much you can do. Have you checked with
technical support for the ODBC provider to see if this is a known issue?