Q: Wildcard characters in queries randomly switching between Access * and Ansi % BACKGROUND:

*I have an Access 2007 application, with a form which builds a Filter string to pass to a Report, which uses a stored query.  

*In Access Options, I have "SQL Server Compatible Syntax (ANSI 92)" checked for This database, and the Filter string includes a LIKE clause with % wildcard characters.
ISSUE:
Randomly when I save or open the application (not sure the exact cause), the effective wildcard syntax switches from needing % to *, or back.  I know this because my query stops working.  
WHAT I'VE TRIED:

*I do a find/replace on the wildcard characters, it works for a while, and then it happens all over again, without making any significant changes to the query or filter.

*Plenty of Compact/Repairs have made no difference.
Any ideas?

A: If you are only using ANSI-92 Query Mode for the alternative wildcard characters (rather than the enhanced SQL DDL and DCL SQL syntax it offers) then consider using the ALIKE keyword in place of the LIKE keyword. 
The advantage is that you can use the ANSI-92 Query Mode wildcard characters in either Query Mode. The slight disadvantage is that the ALIKE is officially unsupported, meaning it might disappear in a future release of the engine (though I would rate this as low risk myself).
