Hvad er galt?

Du mangler sikkert en conn.open efter at du har sat din conn.connectionstring

Nop.. Her er den øverste kode:

<%
\' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject(\"ADODB.Connection\")
DSN = \"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"database.mdb\")

strSQL = \"Select * from jwgbog\"

set rscount = conn.execute(\"select count(id) as antal from jwgbog\")
conn.open

antal = rscount(\"antal\")
set rscount = nothing
%>

ok prøv nedenstående istedet så.

<%
\' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject(\"ADODB.Connection\")
DSN = \"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"database.mdb\")
Conn.Connectionstring = DSN
Conn.open
strSQL = \"Select * from jwgbog\"

set rscount = conn.execute(\"select count(id) as antal from jwgbog\")
conn.open

antal = rscount(\"antal\")
set rscount = nothing
%>

Har jeg lige gjort.. Der kom en fejl:

ADODB.Connection error \'800a0e79\'

Operation is not allowed when the object is open.

/terrorist/stoette/add/add.asp, line 10



Linie 10 : conn.open

sorry min fejl, -du skal fjerne den nederste conn.open

Jeg prøver lige..

Det virker tak