Access Query / ODBC

[ALKnapp]

Hi,
I have several database files and I'm using Microsoft Access to link them. My query runs and displays until I attempt to scroll down. When I page down, I get the following error:

ODBC--call failed
[Microsoft][ODBC Visual FoxPro Driver]Error: Column 7(h_lnamt)(#0)

When I remove the h_lnamt field from the query, it runs and displays fine. The h_lnamt field is very necessary to my query. Any ideas as to what is wrong? I am not extremely familiar with Access so I'm hoping for a solution that isn't too complex. I would appreciate any help on this one.
Thanks!

 

[jiqjaq]

Seems like at least one of the values in that field is not what Access was expecting, given how that field is defined. In other words, the Access definition for that data type from the linked table does not match the FoxPro defintion.

Either the value is not one that Access accepts for that tyoe of data or the data itself is fine, but you're attempting to do an operation on it that doesn't make sense given the value in that field, e.g., there could be a NULL where an actual value is needed.

Immediately after this happens, try entering ?err.description in the immediate window. You might get a better description of the error.