Search results

Second method is definitely better. You do not want to mess with properly quoting text values in SQL. The second approach with ADODB.Command gives you a portable code that you can later use in ASP if required.

You can use software like PHPRunner to convert your MS Access database into a searchable web database. Might be an overkill for what you trying to build.