ASP and Access DB Search

[fluiduk]

Hi All

Working an e-commerce site at the moment and am stuck on the product search.

We are using an access db (soon to be migrated to mysql and php) and asp.

We need a search that can search all of the fields for the products and be capable of and/or searches etc.

Im not really an asp person and Im not sure how to do this.

Can anyone point me in the right direction

Thanks
Aaron

 

[therubble]

look up sql and the "like" keyword, access is terribly slow though. Have you thought about using sql server express, or MSDE. Full text indexing is available in sql express SP1, which is suited to this type of operation.

Microsoft database engines.