What happens when you go to File -> Import external data -> Link Tables, and then pick your data source? Does it show all the tables?
ODBC is a pain, I'm learning. I have a Sybase ODBC connection set up that only works in Office97 -> OfficeXP doesn't like it. Very strange.
Good luck...