Dear reader,
Under Tools>>Options>>Tables/Queries there is a setting possible of "SQL
Server Compatible Syntax (ANSI 92)". The two tick boxes here are
· "This database"
· "Default for new databases"
I have the experience in case tick-box "This database" is ticked (enabled)
the form filter tool-bar option is not longer working properly. What happens
is the automatic filter syntax builder is not longer using the word "Like"
in the filter syntax. Is there same one who knows the meaning of this two
tick-boxes and way the auto filter option of the tool-box is not longer
working as the first one of the two is ticked off.
Thanks for any explanation about this two selection possibilities.
Kind regards,
Simon van Beek