Nah, I've given up.
I can link the tables ok using that odbc and going though the menu.
It doesn't work on the fly in code though, I still get the same error.

Phil.