F E J L ! ! ! ! ! ! !

Set bc = Server.CreateObject(\"MSWC.BrowserType\")
Set DB = Server.CreateObject(\"ADODB.Connection\")
DB.ConnectionString = \"Driver={Microsoft Access Driver (*.mdb)};\" & \"DBQ=d:webs\\mote.dk\\access\\kage.mdb;\" & \"DefaultDir=d:webs\\mote.dk\\access\\;\" & \"FIL=MS Access;\"
DB.Open
SQL = \"SELECT * FROM ting Where Nr= \" & request(\"ting\")
Set RS = Server.CreateObject(\"ADODB.Recordset\")
RS.Open SQL, DB, 3, 3

Jeg får fejl:

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

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

/motechat/enter/egenskaberforting/aabn.asp, line 1794


Request(\"ting\") er et tal eller blandede tal og bogstaver

RS(\"nr\") er en tekstcelle