Hi,
I have quite similar problem, the FindFirst Function of Access 2007 and the NoMuch Function always return True when using back end SQL 2005. Some of other topics in the internet quoting the problem was with Double quote error in our syntax. Hope it helps.