The following is my situation.

Winnt workstation, using odbc 2.04 to connect to btrieve files (ddfs). The
version of btrieve is 6.15. I'm using Access97 and attached ddfs to an
access database and run queries on those attached tables.

I have no problem in attaching tables to ddfs.  But the big problem is when
i try to run queries to those attached tables.  I'm a not allowed to sort
fields in order, or group fields.

When i sort fields in order i recieved an error message of "odbc connection
failed" and then "Scalable SQL cannot create the external index file.
(#234)"

When i group fields i get "odbc connection failed" and then "Scalable SQL
cannot create the external index file. (#234).     The specified terms must
be either group aggregate functions or columns specified in a group by
clause (#818) "

I'm not too sure what that means.  Please help.

My email address is

Thank you very much.