Please Help! I dont know how to use vbDatabaseCompare. I need it for my login form to work!
vbDatabaseCompare uses the current setting of the database's string
comparison operator. Normally this will use the computer's language
setting to handle (e.g.) accented characters, and will be case
insensitive. The alternative vbBinaryCompare will compare the exact
ASCII representation of the character. For example:
The first example finds an x (or X) in the first position of the
string, since it's not case sensitive; the second example requires an
exact match, so it finds the lower-case x in the 7th position.
In the Replace() function this would let you choose between replacing
text in a case-sensitive or case-insensitive manner.
Check this site for more info