I am developing a database application in Access 2.0. In this version
there is a limitations in queries that makes it impossible to run a
query where the total length of grouped fields exceeds 255 bytes. This
is quite a limitation, because I have three text fields which has to be
about 255 bytes each. However, I don't need to group by these fields,
but if I try to turn off grouping (by choosing, lets say 'expression') I
get another error. Is there any easy solution to this problem? I don't
want to cut down the size of the fields, and upgrading to access-97 is
not an option either.
-TB-