if statement ignoring case

[DDonnachie]

Hi,

could someone tell me how this is happening

    If "LetMeIn" = "letmein" Then
        MsgBox "match"
    End If

I am putting password protected user access onto an app and decided to find what would happen if I tried some deliberately false conditions. I realise Security is a bit of a joke with MS Apps but surely not this bad.....so what do I need to do to get this to spot the difference.


oh yeah Access 2003 on XP


just realised... I never actually stated what was happening
The above code will actually show me the MsgBox.

 

[Norie]

David

Access is case insensitive.

Try placing this at the top of the code.

Option Compare Binary

 

[DDonnachie]

ok...... I just thought it was set to 'Database' for a reason ?

Changed it and its working like it should

Cheers Norie