I'm not going to get into details here, but if you want a good starter for building a search engine, visit this address...
http://www.phpbuilder.com/columns/clay19990421.php3
Granted it is for PHP, and it is definitely only a starter, but it may give you some ideas. "May" is the operative word.
Now before everyone responds to say how much of an idiot I am, let me assure I already know that. You said Microsoft Access, ugh! Well... You still need to explain yourself some more. Are you wanting to build a search engine for your website that your users can use, or are you yourself just wanting to search the database. Quite frankly, MS Access is a terrible database... I say this because I have been using it for about 5 years for clients that insist on it while I personally use MySQL for myself. I would never recommend Access as a web database. MySQL is free, faster, more powerful and people won't laugh at you for choosing it. And if you don't like MySQL, or are just partial to PostgreSQL, go the Postgres route. Either one is better than Access by far.
Aaron Zoller
www.AaronZoller.com (Opening in June)
