Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    8

    is access case-sensitive?

    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

  2. #2
    Join Date
    Mar 2009
    Posts
    8
    it's ok, i just compared the UCASE(input) with the UCASE(username) in the database and it works fine

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 11-04-2006, 02:31 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums