How to list all records which is stored in Ms Access DB?

Results 1 to 2 of 2

Thread: How to list all records which is stored in Ms Access DB?

  1. #1
    Maire Guest

    Default How to list all records which is stored in Ms Access DB?

    How do I list all records? <BR>How do I list them in alphabetical order? Any Examples???

  2. #2
    Isabelle Guest

    Default RE: How to list all records which is stored in Ms Access DB?

    This is an example how to list all records.<BR>hope This helps<BR><BR>&#060;HTML><BR><BR>&#060;HEAD><BR>&#0 60;TITLE>All records&#060;/TITLE><BR>&#060;/HEAD><BR>&#060;BODY bgcolor=CornflowerBlue><BR><BR>&#060;%<BR> Dim conn<BR> Dim rs<BR><BR> Set conn = Server.CreateObject ("ADODB.Connection")<BR> Set rs = Server.CreateObject ("ADODB.Recordset")<BR><BR> conn.Open "dns_name"<BR><BR> rs.Open "table_name", conn, 0, 1, 2<BR> <BR> While Not rs.EOF<BR> Response.Write rs("db_field1") & "<BR>"<BR> Response.Write rs("db_field2") & "<BR>"<BR> Response.Write "&#060;hr>"<BR> rs.MoveNext<BR> Wend<BR><BR> rs.Close<BR> conn.Close<BR> Set rs = Nothing<BR> Set conn = Nothing<BR> <BR>&#037;&#062;<BR><BR>&#060;/BODY><BR>&#060;/HTML>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •