When trying something like this:

SELECT projectcode,projectname,clientname
FROM project,clients
WHERE project.clientcode = clients.code

I get the error:
Run-time error '-2147217887(80040e21)':
ODBC driver does not support the requested properties.

George