Search an access db

Topic

New Reply

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.

Reply | Quote

Replies

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:

http://www.w3schools.com[/url%5D and
http://www.4guysfromrolla.com[/url%5D

Hope this helps

Reply | Quote