Anytime I try to execute a query from Microsoft Access (Win95/98) with conditions on data fields receive this error: “Expected lexical element not found: #1015” The same queries executed from NT clients work fine. Anybody knows why?
Take a look at the SQL statements generated by your Access query. There’s a syntax error in there someplace. I have this problem occasionally. Regards, Lee