Case sensitive password (Access 2000>)

Topic

New Reply

Could anyone assist me in making the password Case Sensitive in the “PassDialogForm”. The current password is “pass”, but can be typed “PASS”, “Pass”, “PAss”…you get what I mean. I would like it to only accept “Pass”. Thanx in advance!

Reply | Quote

Replies

Change the first line of the module for the password form from

Option Compare Database

to

Option Compare Binary

This will force string comparisons for that module to be exact. Look up ‘Compare’ in the online help for more info.

Reply | Quote

Thanx… I’ll give both bits of advice some try and see what is useful for this DB.
It is useful to know both ways. The first is quick but will affect the entire module… the other is great only for that sub procedure if I understand it correctly.
thanx again…

Reply | Quote

Correct. My suggestion affects the entire module. If you only have one procedure in the module that compares strings, it is a quick solution. If you have multiple string comparisons in a module, some of which should be case sensitive, while others shouldn’t, Jayden’s solution is the way to go.

Reply | Quote

Correct. My suggestion affects the entire module. If you only have one procedure in the module that compares strings, it is a quick solution. If you have multiple string comparisons in a module, some of which should be case sensitive, while others shouldn’t, Jayden’s solution is the way to go.

Reply | Quote

Thanx… I’ll give both bits of advice some try and see what is useful for this DB.
It is useful to know both ways. The first is quick but will affect the entire module… the other is great only for that sub procedure if I understand it correctly.
thanx again…

Reply | Quote

Change the first line of the module for the password form from

Option Compare Database

to

Option Compare Binary

This will force string comparisons for that module to be exact. Look up ‘Compare’ in the online help for more info.

Reply | Quote

I also like using the StrComp function.

This takes the argumes StrComp(String1,String2, [compare method]). The compare method you can set to compare binary (vbBinaryCompare)

The reason I like this, is that you don’t have to worry about other ‘binary’ comparisons (the less common) through the rest of the module, as you do when you set the whole module to Binary comparisons. But it is only a preference thing.

Cheers

Jayden

Reply | Quote

I also like using the StrComp function.

This takes the argumes StrComp(String1,String2, [compare method]). The compare method you can set to compare binary (vbBinaryCompare)

The reason I like this, is that you don’t have to worry about other ‘binary’ comparisons (the less common) through the rest of the module, as you do when you set the whole module to Binary comparisons. But it is only a preference thing.

Cheers

Jayden

Reply | Quote