how do i get a record with its index from an ms access file?

[Guest_imported]

hello!!! i am making a simple login program. i have three fields in my .mdb table namely indeces, usernames and passwords. when given a string corresponding to username my program must loop through the usernames in my .mdb file, look for the match of that username get its index. i need the index so that i could match the appropriate password to the inputted username? how would i do this? thanks =) ...

 

[bjrollet]

Why the looping? Create a recordset that returns a single record that has all of the info you need. Looping would prove to be way inefficient(esp if you have a large number of users).