Like Converts to ALike in Query

[Guest]

Hello,

Not sure if anyone has seen this but I have a dB that
will no longer perform parameter based queries using the
LIKE keyword. Instead it changes it to ALike and cannot
be saved or run in anything other than ALike. Even if I
correct the SQL code to Like it corrupts to ALike. I've
created other dB since this first started occurring and
all are doing the same thing yet dB created prior to this
event still perform a "Like" keyword selection.

Is this something unusual or have I missed an M$ upgrade
somewhere?

Help!

 

[Michel Walsh]

Hi,


Like and ALike difference SHOULD be about the wild card characters you use,
the DOS ones, ? and *, or the UNIX ones, _ and % . I *think* it is there to
help to explicitly mention what you want to use without having to relay the
Options (Tools | Options..."| Tables/Queries, Compatible Syntax ANSI-92 )
when you are outside Access "reach", but still under JET (such as in
validation rules definition). See Access 2002 help file under "Examples of
field validation rules (MDB)".



Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

Thank you very much.....that did the trick. I had to
uncheck the SQL Server Compatible Syntax(Ansi92) in the
option for the dB. It's rather odd that the switch would
have been made without my knowledge but perhaps that's
best left for another question.

Once again, thank you!!!