I have a cash receipts system based on a DB2 database I am connecting to using ADO with ODBC. I can connect, and I can see the tables I want to access. I have a username/password (cashrec/******) I plan to use as my application userid, and will manage security within the application. Tables have been created in DB2 which are owned by PRIMARY (i.e. primary.cash, primary.user, etc...) The user has also created "aliases" which should allow me to get the tables without a fully qualified name (USER instead of PRIMARY.USER)

Whenevery I try to log on and acces the tables, I get messages saying "CASHREC.USER is not a defined field" (apologize for not having the exact message - I don't have remote access and am writing this from memory at home.)

Unfortunately, my client does not have a good understanding of DB2 and how to properly set up the tables to pass an OS userid (as in setting up synonyms in Oracle) and I have no experience with DB2.

I am hoping to continue to use ADO controls, otherwise I will have to revert to using DAO and rewriting this App.

Any ideas are welcome...