search record using search button from database

[faisyshah]

hello every body

i have a search button just like in google or yahoo but my search button is connect from my access database table , basically search option is use in my site for product available for sale for example when customer type name of product in search option and then click on search button , if product available then the next page show description about that product otherwise show "product not found"

any solution or code

thanks in advance

[faisyshah]

my frontend is asp and and backend is microsoft access

[amitlokare]

my frontend is asp and and backend is microsoft access

hi,
U can fire query on search button like
select productname form product where productname like %"request.form("serach")"%
Then use tht recorde set