I googled the error message, and found this: i-Wa: Fix: Errno 3502, no GRANT or GRANT compatible permit exists
The search didn't brought a lot of links, the few others talk about missing access.
Hope you will get an answer from IT.
Thanks, planteg. That (and the few search results like it) are the only things I have found, and they are not very helpful except that I can send them to IT.
It's odd because the user credentials do have access white using the native front-end app, so that's why I'm thinking the checkbox is the issue.
I doubt anybody has run into this because it's very specific, but if anyone has the odds are that this message bard will help.
maybe the user can access the table with the native front-end, but not through ODBC.