Yes - I use the same login id and password the app is using when I tested through Query Analyzer and Access.

All of the tables are owned by dbo. Even if I give the table explicit permissions to the tables, the application still cannot access them.

I have no overriding "DENY" permissions. I even dropped and recreated the tables to see if that would correct the issue. That is when I added the SysAdmin to see...