Access 2002 vs 97 and ODBC

[jeffbert]

I am connecting to a table via ODBC using Access 97 and everything works
fine. When I try to connect to the same table via ODBC using Access 2002, I
get the "ODBC call Failed" message and all of the values in the table are
#Name?.

Why would this work in one version of Access, and not the other, and how do
I fix this?

Thanks

Jeff