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 Memo
s. 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
andID
field will be there by default) in MS Access. - Add a field called
Field1
of typeMemo
- 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.
select 1;
work?select * from Table1;
?distinct
does not play nicely withmemo
.