- <%
-
set conn=Server.CreateObject("ADODB.Connection")
-
conn.Provider="Microsoft.Jet.OLEDB.4.0"
-
conn.Open "c:/inetpub/myAccessDatabase.mdb"
-
-
set rs=Server.CreateObject("ADODB.recordset")
-
rs.Open "SELECT * FROM myTable WHERE date = #12-13-2006# ORDER BY name", conn
-
-
do until rs.eof
-
for each x in rs.fields
-
response.write x & ": " & rs(x) & "<br>" & vbNewLine
-
next
-
rs.movenext
-
loop
-
-
%>
Here's a simple example. Here's
a good tutorial
Let me know if this helps.
Jared