请问ACCESS数据库如何按索引查找

[choge]

通过ADOQuery连接ACCESS数据库，库里有一个字段ID,已建立索引，索引名为indexID，请问如何写SQL语句
按字段查找：sql = "select * from Table order by ID desc"; 按索引怎么写呢？参考别人的写法如下会报错
sql = "select * from Table order by indexID desc";
sql = "select * with index( indexID) from Table order by ID desc";
sql = "select * from Table order byindex( indexID) desc"; 均报错
请大家赐教