i just wanna know how u can do this... i just want to have a variable say "username" as each user has their own table (Access 2000) how can i select the table by using the variale in the below statment

strSQL = "Select * FROM (USERNAME VAR HERE) WHERE" _
& "WHERE Topic_Number=1;"

any help would greatly appreciated

strSQL = "Select * FROM (" &Session("username") &") WHERE" _
& "WHERE Topic_Number=1;"

SELECT * FROM " & Session("username") & " WHERE Topic_Number = 1;