ORDER BY not supported for CREATE TABLE query.
From Microsoft Office Access 2003
ORDER BY not supported for CREATE TABLE query.
There is an error in the syntax of your query. The Query Designer has attempted to locate the source of the error. Review your query syntax and correct the error before running your query.
For more information, see Reorder Output Columns in a Query.