Hallo DAN,
ich denke das ist ein Hinweis:

Microsoft Access version 7.0
----------------------------
Problem:
When the "Sort by" feature of Access is used on an AS/400
table, it sometimes reports this error:
SQL0208 - ORDER BY column 'column_name' not in result
table.

Cause:
The Microsoft Jet Database Engine will use the ODBC
cursor library to implement the select. The SQL
statement will actually be modified by MS Access (JET)
to first retrieve all records for the unique keys. This
is the statement that will contain the invalid syntax.
Access generates an invalid SQL statement where it is
trying to SELECT one column and order by another column
which is not selected. This is not valid ISO SQL-92 syntax.
Use the SQL log utility in the ODBC administrator if
you would like to see the incorrect SQL statement.

Workaround:
Access requires that you order by a keyed field.

Gruss TARASIK