Here is a quick sample for you to load the dropdown from the access table.
Assuming that you have already established a connection to database, lets say object name is con.
Now Define a recordSet in your ASP page and populate the drop-down

< %
sql="SELECT field_to_display FROM table_name "
Set rs=con.execute(sql)
% > 
<select name="myoptions">
<option selected>
 < %
  Do While Not rs.eof
  Response.Write(" <option value= " & rs("field_to_display") & " > " & rs("field_to_display") & "</option>")
  rs.movenext
  Loop
  Set rs=Nothing
 % >
</select>