I have an code that i use to retrive data from access DB and to show into textbox. <% try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con=DriverManager.getConnection("jdbc:odbc:OBS","",""); } catch(Exception e) { out.println(e);} if(con!=null) { try { Statement statement = con.createStatement(); ResultSet rs = statement.executeQuery("SELECT * from userform where srno='"+id+"'"); while(rs.next()) { n=n+1; %> <input type="text" name="fname" value="<%=rs.getString(2)%>" width="15" />