---
title: "Microsoft OLE DB Provider for ODBC Drivers error '80040e07'"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/78175-microsoft-ole-db-provider-for-odbc-drivers-error-80040e07"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "magnusfeldth"
published: "2003-05-26T19:38:19.000Z"
updated: "2003-05-26T19:40:57.000Z"
replies: 2
views: 198
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/78175-microsoft-ole-db-provider-for-odbc-drivers-error-80040e07"
---

# Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

## #1 — magnusfeldth, 2003-05-26T19:38Z

vad är felet? Det gäller where-alternativet: när en kolumn som heter mainpage har värde 1 skall posterna visas...

```
 <% Set Connect = Server.CreateObject("ADODB.Connection") 
Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" &Server.MapPath("addemalmbergadmin/tubsockan.mdb")

	Set RecSet = Server.CreateObject("ADODB.Recordset")
	SQLsats = "SELECT * FROM sockrates WHERE Mainpage = '1' ORDER by ID DESC "
	RecSet.Open SQLsats, Connect, adOpenStatic, adLockOptimistic
%>
```

felmess:

```
Microsoft OLE DB Provider for ODBC Drivers error '80040e07' 

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

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

## #2 — Sebbe, 2003-05-26T19:40Z

Tal ska inte omringas av ''.

```
SQLsats = "SELECT * FROM sockrates WHERE Mainpage = 1 ORDER by ID DESC"
```

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

## #3 — Josef, 2003-05-26T19:40Z

Tror inte det ska vara fnuttar runt 1

```
SQLsats = "SELECT * FROM sockrates WHERE Mainpage = 1 ORDER BY id DESC"
```

Sedan är ett tips att byta ut

```
Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" &Server.MapPath("addemalmbergadmin/tubsockan.mdb")
```

till

```
Connect.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("addemalmbergadmin/tubsockan.mdb")
```

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/78175-microsoft-ole-db-provider-for-odbc-drivers-error-80040e07