Ok now i got the previous thing working i got a follow up question:
I wanted to use the query in my program

VB Code:
  1. objData.SQL = "sp_ZoekKlantOpNaam"
  2.                 objData.InitializeCommand()
  3.                 objData.AddParameter("@KlantNaam", Data.OleDb.OleDbType.VarChar, txtZoekKlant.Text.Length, _
  4.                    "*" & txtZoekKlant.Text & "*")
  5.                 objData.OpenConnection()
  6.                 objData.DataReader = objData.Command.ExecuteReader

The addparameter is just a functions that grabs the content of the textbox and passes it to the query, this works fine, used it lots of times in my project.

So whan i entered *pee* in Acces i got a result from the query. Now when i do basicly the same but then from vb i get nothing

I also tried replacing * with % without any luck

Hope someone can help me