What is wrong with this recordset? Expert help needed..

[btn]

Hi - using ASP/Access/Vbscript

Using the recordset below to insert a hit in my database each time the page is
viewed by a user.
Like a "how many times page is displayed record".

But sometimes the whole webpage crashes. It started to happen after I used
this recordset, so I think that it may be the reason.

Is there an expert out there that can look at it an tell me if the recordset
is ok or bad.
Here it is; (viewCount is the DB table that holds the hits).

<%
Dim profiler
Dim profiler_numRows

Set profiler = Server.CreateObject("ADODB.Recordset")
profiler.ActiveConnection = MM_mypage_STRING
profiler.Source = "SELECT * FROM profiler WHERE ID = " +
Replace(profiler__MMColParam, "'", "''") + ""
profiler.CursorType = 0
profiler.CursorLocation = 2
profiler.LockType = 3
profiler.Open()
profiler("ViewCount") = profiler.Fields.Item("ViewCount").Value + 1
profiler.Update

profiler_numRows = 0
%>

Any comments? Other way to do this?

Bjorn.

[Chris In Madison]

I think the correct syntax is:

profiler.Fields("ViewCount") = profiler.Fields.Item("ViewCount").Value + 1

Just a wild guess, however, according to this code sample at ASP101:

[url]http://www.asp101.com/samples/viewasp.asp?file=db%5Fupdate%2Easp[/url]

Best regards,
Chris