---
title: "DELETE problem!"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/72184-delete-problem"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "JannesBoy"
published: "2003-03-26T06:37:01.000Z"
updated: "2003-03-26T09:03:39.000Z"
replies: 3
views: 292
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/72184-delete-problem"
---

# DELETE problem!

## #1 — JannesBoy, 2003-03-26T06:37Z

Hej! 

\<%
Set connect = server.createobject("ADODB.connection")
connect.open "driver={Microsoft Access Driver (\*.mdb)};dbq=" & Server.MapPath("gastbok.mdb")

id = request.querystring("ID")

SQL = "DELETE FROM gastbok WHERE ID = '"& id &"'"
connect.execute(SQL)
connect.close

response.redirect("login.asp")
%\>

Kan någon säga vad som är fel?

Felmeddelandet:

Microsoft OLE DB Provider for ODBC Drivers fel '80040e07' 

\[Microsoft\]\[ODBC Microsoft Access Driver\] Data type mismatch in criteria expression. 

/trash.asp, rad 8

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

## #2 — trexter, 2003-03-26T06:40Z

Ta bort ' och ' runt id. id är av typen tal.

 :)

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

## #3 — Sebbe, 2003-03-26T07:20Z

Och byt sedan ut

```
connect.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("gastbok.mdb")
```

mot

```
connect.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("gastbok.mdb")
```

 :)

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

## #4 — cyprys, 2003-03-26T09:03Z

<https://www.connectionstrings.com> ;)

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/72184-delete-problem