Query question

Question

Hey, Im accessing a Access database from my program. The database contains password. For some reason tho my query's are not being case specific. Example: PAssWoRD is the same as password or PASSWORD. This is not cool. I was wondering if its the something with OLEDB or if its just with an Access database? Thanks.

Answer 1

Ahhh yeah thats a good idea.. I my query was just a select (*) where password = password.. I guess pulling it and comparing it will work and just as easy. Thanks. :D

Answer 2

This can be an issue with any database. SQL Server is not case specific, and apparently Access is as well(don't know for sure about Oracle). I know how to fix the issue in SQL Server, but I've never dealt with it in Access. Here is a page I found that helps somewhat: http://support.microsoft.com/?kbid=209674 Alternatively, you could do a select on the database for the given username. Select the password, it should be returned to you with the case retained, and then you can do the password comparison within your code.

Answer 3

Hi...... It is from Access..... Good luck......