I have been working on a relatively easy project. .at least it seemed so. I need to access a small number of records from a 54000 record table. Bad news, the table is not ordered in any good way, so I have to "brute force" my search for my records. I have tried several methods of access including ODBC data connections with SQL and data access objects. The SQL works as long as i don't apply a WHERE. The WHERE generates an divide by 0 error. Unfortuanatly, if the data is the cause there is nothing i can do about it. . .the data is "untouchable" per managements orders (yes i am opening it in read only mode!) Right now i have the program open the datasource with a data access object, do a movelast, then perform my work. It is not too bad this way. If i do it with the ODBC data connection and sql it takes about 3 minutes to open. anyone have any advice on how to speed up this process? Oh, one more thing. The data is on a remote server connected by a high speed WAN. Any ideas would be appreciated! David Moore
dm7941@sbc.com
