Re: ODBC Problem: Tables not found

Hi , Vince You created your database objects under NT administrator account. In Fact , your administrator name's length over 8 characters. When you used ODBC driver to connect OWS , the error appeared. You can use informix account to create you database objects. Use any informix account name's length < = 8 characters , you can connect OWS. Sorry , my English is not good. Paul Hsiung Vince Bryden wrote: > Hello there all...I am at the end of my rope and would > appreciate all the help I can get... > > I have a Informix 7.22 running on NT workstation and have > successfully created my tabes, SP's, triggers, views, etc > through the SQL tool provided... > > BUT.. > > I open up a new database in Access and try to attach to these > tables...I get a list of my tables....so far so good... > > THEN... > > I get the error message "table Adminst.Orders not found in database..." > What's going on? Is there something special to having Access and > Informix on the same machine? (typical developer environment...) > > Is there something I've overlooked? > > ANY help would be appreciated...I'm sure it must work and I'm doing > something stupid or else this newsgroup would be flooded with such > messages... > > Help me out guys.... > > Thanks....