sql="select * from users"
provider="provider=microsoft.jet.oledb.4.0;"
dbpath="data source=" & server.mappath("countu.mdb")&";"
con.open provider&dbpath
set rs=server.createobject("adodb.recordset")
rs.open sql,con,3,2
rs.movefirst
provider="provider=microsoft.jet.oledb.4.0;"
dbpath="data source=" & server.mappath("countu.mdb")&";"
con.open provider&dbpath
set rs=server.createobject("adodb.recordset")
rs.open sql,con,3,2
rs.movefirst
provider=System.Configuration.ConfigurationSettings.AppSettings ["ConnectionStr"]