I've been trying to find a way to make access case-sensitive. in one of my tables I have a Aw and a AW. is there any way I can make it so they both don't look the same in access.
The alternative, Option Compare Binary, will cause code in that module into case sensitive comparisons but it won't affect the built-in StrComp and InStr functions.
You could go to the trouble of making a case sensitive version of these functions in a public module so they could be used in the database but adding the third parameter to the existing functions seems a lot easier.