Database connection

What's wrong with this code????

Code:

---

Produkt = "Ton"
adoPrimaryRS.Open "select PRODUKT,OLDARTNR,NEWARTNR,LEVARTNR from KROSSREF WHERE [PRODUKT] like '*" & Produkt & "*'", db, adOpenStatic, adLockOptimistic

---

This should return all records containing "Ton", that is "Ton, tone, toner" and so on.
But it doesn't return anything at all!?:confused: :confused: :confused: :confused:

i think it is because you use [produkt] for the row (or whatever) but also use PRODUKT for the search name :S...

Nope, allready tried that....

use % as wildcards, not *

THANKS ALOT!!!
That solved it

good :)

always use % when working with ADO, the good o'l DAO likes the * ADO will not tolerate them :)