hi there!
i'm working on a web site using asp and ms access. if someone wants to login he/she enters a username and a password in flash textboxes, then i have an asp page that checks the username and the password. it worked fine until a user that had registered with an uppercase username wanted to login with a lower case (same) username but couldn't. how can i do the case insensitive check? many people have registered already, i don't want to change their usernames into lower case, i just don't want the check to care about it. is access case sensitive or not anyway??
thanks