ODBC... call failed using parameter, okay enteredas criteri

[TheKval]

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? :

[Steve Jorgensen]

On Wed, 18 May 2005 02:06:37 -0500, Th*****@nwbedding-dot-com.no-spam.invalid
(TheKval) wrote:

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? :(

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?