<%'-----------------------------------------------------------'###########################################################var_db_path = "your database path"'###########################################################'-----------------------------------------------------------' set the database connectionset db = server.createobject("adodb.connection")' open database connectiondb.open "provider=microsoft.jet.oledb.4.0 ; data source="&server.mappath(var_db_path)' set the recordsetset rs = server.createobject("adodb.recordset")%>then, in your page you can do something like this.CODE<%set rs = db.execute("select * from table")%>