% Option Explicit %> <% Dim connCW, rsItem %> <% Set connCW = Server.CreateObject("ADODB.Connection") %> <% connCW.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("registration.mdb") %> <% Set rsItem = connCW.Execute("SELECT * from students") %>
| ID | First Name | Last Name | State |
| <% =rsItem("sid") %> | <% =rsItem("first") %> | <% =rsItem("last") %> | <% =rsItem("state") %> |