Case sensitive login

[CHEECO]

I am using Security Levels 2012 as a login for a Database. It works well but it does not have case sensitive. I would like to add this to it if possible. Code that I can add to existing Module or to a new module. I am using access 2016. I have attached a copy of the file. I am also open to a new login database that has case sensitive if someone know of one and can direct me to it or attach to this post.



Thank-you

Cheeco

[orange]

Is this an interface to Quickbooks?(I found this only via Google).
I recommend you give readers an overview of what you are talking about/trying to develop.

[CHEECO]

I have Security Levels 2012 for an MS access database. But it is not case sensitive and I am looking for the proper code to ad to a module that will make it case sensitive.

[aytee111]

According to the below, there is a command StrComp and then you select a binary comparison.

http://access-excel.tips/access-strc...ve-comparison/

(Nice information provided in attachments!)

[orange]

What exactly do you want "case sensitive"?
Where exactly do you want to check for "case sensitive" data?

As aytee said strComp with binary option can check case sensitive.

You can open the code, but you need to identify your requirement.

[isladogs]

In general, Access is case insensitive so it would treat cheeco, CHEECO, cHeeCo and any other combination as the same in the user name box.
The only way to get what you want is the StrComp function given in the link by aytee.
Note that counterintuitively, the result is 0 if the compared values are the same and 1/-1 if different.

[CHEECO]

Lets say the user has a user name that is "Buddy" and a password that "Holly" and that is what is stored in the table. As it is the user can type in his user name like "buddY" and his password "hollY" and he is still granted access and logged in. What I want accomplish is that the user not be granted access unless the user types in his or her user name and password exactly how it is stored in the table.

[isladogs]

Understood. Use StrComp as already explained.