actually i did not add anything to that code exccept for the name of the variables
the rest was built by ms access

Access is not ASP.

The query might run fine in Access, but for you to pass it to the Access database, it needs to be a valid string.

The recommendations about quotes etc is one piece of the puzzle to make this work from an ASP page.

You may need to read up a bit about ASP and Access in general. Once you understand concepts like string concatenation, you'll be able to build better sites quicker.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Ok, I'll do that.
thanx

The problem was the that last part after where cluse.

it should be like this:
------------------------
WHERE (((tblBooks.Title) Like '%" & Replace(Recordset1__vtitle, "'", "''") & "%')) OR (((tblBooks.AuthorName) Like '%" & Replace(Recordset1__vauthorname, "'", "''") & "%'))"
------------------------

the idea of the string concatenation in some short e.gs
----------------------------------------------------------
you must use & to concatenate strings in VBScript

you want the sql to look similair to this

select * from table where field like '%something%'

so build it like this

Code:
something = "something"
sql = "select * from table where field like '%" & something &"%'"
and if you want it to look like this
select * from table where field like "%something%"
use "" like this

Code:
something = "something"
sql = "select * from table where field like ""%" & something & "%"""


Thanks to nofriends.

Yeah, that looks much better....

I am not sure if all databases support the double quote as a delimiter, so it's better to stick to the single quote.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

quote][ so it's better to stick to the single quote.[/quote]


Yes,I'll try to work more on such e.g (sql statements) to know it better.
MANY THANKS to you too Imar, you are a great support.