Why does query convert "Like" criteria to "ALike"

D

dishrag86

Sometimes queries seem to go corrupt and when I type "Like" (without quotes)
into my criteria as soon as I click out of that criteria, it changes to
"ALike". Any ideas?
 
A

Allen Browne

Uncheck the option to use "SQL Server Compatible syntax."

In Office 2007, click the Office button (top left) and then Access Options
(bottom of dialog.)

In earlier versions, it's Tools | Options.
 
Top