Copyright 2003 SYNERGY. All rights reserved.

<% set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open "c:/db1.mdb" set rs = Server.CreateObject("ADODB.recordset") rs.Open "Select regNo,status from ststatus", conn %>