Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2002
    Thanked 0 Times in 0 Posts

    Search an access db

    I was wondering what I would have to do to have a page on my html web site that searched an access 97 database. It's very simple with only 5 fields. There are 3 search criteria options. In one field, you would be able to put the first letters of the name you wanted to search for and it would return any name that started with those letters. The other 2 are combo boxes where you could choose a parameter and it would only return records that met that criteria. I was hoping that I didn't have to learn VBScript to do this one page. Any ideas? If it would help, I could give a link to a page that does what I'm looking to do. Let me know.

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Indianapolis, Indiana, USA
    Thanked 0 Times in 0 Posts

    Re: Search an access db

    There are quite a few ways to make this work. You'll probably find that ASP is the easiest. You can generally put together a search and results page with ASP in less than 200 lines of code (including the HTML).

    You'll need to use ADO's Recordset and Connection objects.

    I got started with the examples and documentation included with IIS (on Windows NT/2000/XP Pro).

    A couple of great resources (complete with examples) are: and

    Hope this helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts