Query question

kyle_hankinson

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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

kyle_hankinson21y ago
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
0
ytram521y ago
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.
0
abdullah21y ago
Hi...... It is from Access..... Good luck......
0