<%<br />
set conn=Server.CreateObject("ADODB.Connection")<br />
conn.Provider="Microsoft.Jet.OLEDB.4.0"<br />
<br />
dim a, b,c <br />
<br />
a = Now<br />
b= Request.ServerVariables("REMOTE_ADDR")<br />
c= Request.ServerVariables("REMOTE_HOST")<br />
conn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source="& Server.MapPath("sitestats.mdb")<br />
<br />
strSQL = "INSERT INTO tblStats (Recorded, RemoteAddress, RemoteHost) VALUES ('"& a &"','"& b &"','"& c &"')"<br />
<br />
conn.Execute(strSql) <- this line error saying that it is operation must use updatable query<br />
<br />
conn.close<br />
Set conn = Nothing<br />
%><br />
thanks for the answer after i added the permission for it. will choose u as a best ans. thanks<br />
<br />
another question, is there any betterway to implement for every pages for this other than add this additional code to each webpages?<br />
set conn=Server.CreateObject("ADODB.Connection")<br />
conn.Provider="Microsoft.Jet.OLEDB.4.0"<br />
<br />
dim a, b,c <br />
<br />
a = Now<br />
b= Request.ServerVariables("REMOTE_ADDR")<br />
c= Request.ServerVariables("REMOTE_HOST")<br />
conn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source="& Server.MapPath("sitestats.mdb")<br />
<br />
strSQL = "INSERT INTO tblStats (Recorded, RemoteAddress, RemoteHost) VALUES ('"& a &"','"& b &"','"& c &"')"<br />
<br />
conn.Execute(strSql) <- this line error saying that it is operation must use updatable query<br />
<br />
conn.close<br />
Set conn = Nothing<br />
%><br />
thanks for the answer after i added the permission for it. will choose u as a best ans. thanks<br />
<br />
another question, is there any betterway to implement for every pages for this other than add this additional code to each webpages?<br />