What is OPTION COMPARE DATABASE
Here is the KB article on this but it still doesn't explain it well.
I noticed in the MS Access Menu Tools-> Options->General Tab there is a combo box titled
New Database Sort Order
but this only has languages or the General selection
If mine is set to General how is my VBA compiler evaluating my string comparisons? Is it using Binary or text comparisons?