The Joys of the Jet Engine

Informix Dynamic Server Version 7.31.UD5 DYNIX/ptx 4.0 V4.4.10 i386 SunOS 5.8 Generic_108528-20 sun4u sparc SUNW,Sun-Fire-480R Access 97 ODBC Driver INFORMIX 3.80 32 BIT I unfortunately have a business user created MSAccess group of databases that defies belief, but, guess who has to try and make some sense of the structure and queries. I have been attempting to create some of this summarised data on the Sun, extracted from the DYNIX (UmaQ), linking these tables into the MSAccess environment. We are not getting the performance we would hope for, although, not totally unexpected. The business are refusing to give up MSAccess as they wish to continue to produce a multitude of adhoc queries, which only make the whole position worse. The databases are creaking at the seems and they need compacting every week to avoid the size limitations. We have already moved tables into their own database and with the growth continuing they will cease to function within a short timescale. Has anyone experience using large tables with complex queries in MSAccess linked to Informix tables? Would you be prepared to impart your knowledge to guide me in this? In the long term we will have to provide a back-end application with some client-side FE, but, initially I must try and stop the environment colapsing. I do have some linked tables that appear to perform reasonably well but the more complicated enquiries just fail to perform. TIA Geoff ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ********************************************************************************** sending to informix-list