I too have had strange issues with Microsoft Access queries before. In cases when I was building queries automatically via Visual Basic, some of my queries would issue errors pertaining to the line above. The problem was caused by my not using carriage returns. Isn't that typical... If it isn't a carriage return, it's a darn semicolon, or some other single character.
Without seeing the SQL, I cannot say if that is the cause. But if you are using the query builder to write your sql, then carriage returns are probably not the problem. If some of your queries that use LIMIT work and others do not, then it is likely a syntax problem. But again, without seeing the SQL it is hard to say.
AZ
"The crazy kid that programmed http://www.SpilledThoughts.com in three months and now he is really tired."
