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
IDfield will be there by default) in MS Access.
- Add a field called
- Add some random data and
- Try to run this query:
SELECT DISTINCT Field1 FROM Table1 ORDER BY Field1
SELECT * it will work but won't be uniquer because it will consider the
If you don't get an error please let me know because that would mean my database engine is messed up.