---
title: "galen update"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/39362-galen-update"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "jboy_87"
published: "2002-03-10T10:32:19.000Z"
updated: "2002-03-10T10:54:01.000Z"
replies: 1
views: 177
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/asp/39362-galen-update"
---

# galen update

## #1 — jboy_87, 2002-03-10T10:32Z

varför funkar det inte??

får:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
\[Microsoft\]\[Drivrutin för ODBC Microsoft Access\]Fel i rad 
/chat.asp, line 32

```
<%
Set Connect = Server.CreateObject("ADODB.Connection") 
Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq="&Server.MapPath("Database/members.mdb")&""
Set RecSet = Server.CreateObject("ADODB.Recordset")
Addera = "Select * From members where id = " &Session("id")
RecSet.Open Addera, Connect, adOpenStatic, adLockOptimistic

Recset.addnew
Recset("startchat") = now()
[b]Recset.update[/b]
recset.close
connect.close
set Recset = nothing
set connext = nothing
%>
```

Permalänk: https://www.webforum.nu/p/39362

## #2 — jboy_87, 2002-03-10T10:54Z

gjorde såhär istället funkar nu!!

```
<%
'########################## start ##########################
set connect22 = server.createobject("adodb.connection")
Connect22.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("Database/members.mdb")&""
connect22.execute "update members set startchat = now() where id = " & session("id"),,128
'#############################################################################
%>
```

Permalänk: https://www.webforum.nu/p/622253

---

Tråden på webben: https://www.webforum.nu/amne/asp/39362-galen-update