ASP and SQL

Hey im trying to design a log in type page with an access database and im trying to put a variable into the SQL statement and its not letting me do it

dim mySQL
mySQL = "SELECT * FROM USERS WHERE USERNAME='" & Request.Form("username") & "'"
set recordCollection=connectionToDatabase.Execute(mySQL)
connectiontodatabase.


any help???

it doesnt work that way! you have to first of all create a sqlconnection type and then if you want to use mssql create a sqlcommand and bind it to the sqlconnection thru the CreateCommand().