Re: Troubles with informix ODBC drivers when using ms-access

Gerhrd Schmied wrote: > > Hello all! > > I am developing a client/server application with an ACCESS-client and an > informix-server. At the beginning of my work everything went ok and I > didn't have any troubles at all. But now I am working with more > complicated queries which consist of about 80 columns. If I try to > insert new values into a table I get the error message "Query too > complex". If somebody could help me I would be pleased to get a short > message. Thanks a lot > > Gerhard Schmied > Joanneum Research > schmied@ima023.joanneum.ac.at This is an access error indicating you have too many columns in the query window. The Access Jet query optimizer barfs at a certain point. What you need to do is split the query into two parts or better yet, if you are including the contents of an entire table, use the <table name>.* as a selection criteria. Access treats this as one field entry in the optimizer (since it is simply joined data and not searched data). Justin jbunnell@ix.netcom.com