The problem is caused by the ADO layer between your page and Access. Although Access usually requires the * as a wild card, for ADO you should pass the percentage symbol. This:
Code:
SELECT * FROM StoreList INNER JOIN techEnquiry ON StoreList.pkStore=techEnquiry.pkStore
WHERE StoreName LIKE '%S%'
should do the trick.
You can also leave the semi-colon at the end, if you want.
Cheers,
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.