Weird error on simple query in MsAccess Any idea what's wrong with the query 

SELECT DISTINCT Table1.Description
FROM Table1
ORDER BY Table1.Description DESC;


I'm running this on MsAccess on a table where all fields are Memo. There are no indexes, primary or anything like that just a bunch of Memos. I'm getting the error Reserved error (-1060); there is no message for this error.

If you think my query is OK please let me know because I just had a problem with MDAC being corrupted and had to reinstall so it could be related to that.

Edit: OK I narrowed it down so you guys can try to repro: 


Create a blank database (table Table1 and ID field will be there by default) in MS Access.  
Add a field called Field1 of type Memo 
Add some random data and  
Try to run this query: SELECT DISTINCT Field1 FROM Table1 ORDER BY Field1


If you SELECT * it will work but won't be uniquer because it will consider the ID field.

If you don't get an error please let me know because that would mean my database engine is messed up.
Which MS Access version are you using?

Depending on MS Access version it's not possible to order by memo fields. You will need a workaround like:

ORDER BY Left(Description, 127) DESC