If I use this code, Error 3001 is shown.

mystring = "*pub"
Adodc1.Recordset.Filter = "name LIKE '" & mystring & "'"

I know '*' and '%' at the first mke this trouble.
My question is how I can filter this type terms.

For ADO you always use % as the wildcard, not *

I have used a bookmark in Access ADO for years using "*" & Me.ProductFilt & "*" and works, I find the products, yet now when I get here it crashes rst.Filter = varMyBkmrk(), yet the bookmarks are assigned. Has never crashed before, have lots of finds just like this and they all crash now