Hi there. Does anyone know how to execute an SQL select statement on a MDB database, and return a value to a VB variable?

For example, If I was to execute 'select UserName from users where UserId = 123' on the database, how could I get the result into a VB variable?