Searching Access 2003 database for string

[bluejaguar456]

Hey Guys,

I am wanting to search a database for a specific word, well user name. At the moment if the username is eb123 and i type in eb it finds the username. i want it to be able to only find the username if the full text is typed can this be done?

If you know of a more effective way of storing use settings password usernames etc please let me know.

Thanks

 

[PlausiblyDamp]

What code are you currently using to query the database?

 

[bluejaguar456]

The SQL i am using to query is:

sql = "SELECT * FROM UserInfo WHERE [UserID] LIKE %" & Trim(UsernameTextBox.Text) & "%"

 

[PlausiblyDamp]

sql = "SELECT * FROM UserInfo WHERE [UserID] =" & Trim(UsernameTextBox.Text) & ""

would do the trick, however be aware that concatenating strings like that can cause other problems (including security risks), you would be much better off using a parameterised query instead.

 

[bluejaguar456]

Thanks,

i will have a look at a parameterised query, i have never used those before as i am still learning and this is my first big project.

Thanks Again

 

[PlausiblyDamp]

http://www.computerhelp.forum/showthread.php?p=463520#post463520 might be useful then.

 

[bluejaguar456]

Thanks Great Help.