Lost automatic Like operator???

[nobody]

Howdy!

I had to recover some Access 2K2 databases from an image. All the
databases EXCEPT one behave normally. The one that doesn't exhibits
the following behavior.

When I type *something* in the criteria grid of a text field in a
query and then press Enter, the expression IS NOT automatically
changed to:

Like "*something*"

Anyone experience this and what might a solution be to get it working
again. I already did compact and repair, but no joy.

TIA
Al

 

[Van T. Dinh]

I am not sure of your description but the normal usage of Like doesn't go
with Is. Usually, you have:

Like "*Something*"

or

Not Like "*Something*"

In the Query Grid, I normally use Is only with Null, IIRC. For example:

Is Null

or

Is Not Null

 

[Gary Walter]

I had to recover some Access 2K2 databases from an image. All the
databases EXCEPT one behave normally. The one that doesn't exhibits
the following behavior.

When I type *something* in the criteria grid of a text field in a
query and then press Enter, the expression IS NOT automatically
changed to:

Like "*something*"

Anyone experience this and what might a solution be to get it working
again. I already did compact and repair, but no joy.

real WAG, but in Tools/Options
in the Tables/Queries tab, is box
checked for "This database" for
"SQL Server Compatible Syntax (ANSI 92)"

if so, then when you type in

%something%

it automatically changes to

ALike %something%

but no change if type in

*something*

I assume because they use different
wildcard characters

 

[nobody]

real WAG, but in Tools/Options
in the Tables/Queries tab, is box
checked for "This database" for
"SQL Server Compatible Syntax (ANSI 92)"

if so, then when you type in

%something%

it automatically changes to

ALike %something%

but no change if type in

*something*

I assume because they use different
wildcard characters

Your WAG was right on the mark!! Unchecked the box and all is fine!
Thanks!!!