Tælle antal poster i en DB

prøv med
Sql = \"Select count(*) as Found from din tabel\"

herefter er det så bare at printe/vise værdien Found

SQL=\"SELECT * AS antal FROM tabel\"

jeg vil tro at dette vil virke
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"min_db.mdb\")

Sql = \"Select count(*) as Found from mintabel\"
Conn.Execute (SQL)

Set rs = conn.Execute(SQL)
Response.Write rs(\"found\")

slf virker det, det er jo bare simpel SQL

det virker :-))