Here is a quick sample of searching a DB for certain records. It's really no different then doing any other query except that you need to use wildcards. In ASP / ADO the wildcard character is %. It works the way most of us have come to expect * to work. Why is it %? I have no idea, but it is. An Access 97 version of the database is available for download.

This is an overview of SYSTEM DSN's, DSN-LESS Connections, and any database permissions that may need to be set on the server. Helpful for people just learning ASP as well as people with some experience.

To database or not to database? Test of consumed resources (processor, memory) and results with file upload to database or file system. Test of JetOLEB connection to MDB, test of MSSQL 2000 and AppendChunk method and UPDATE text SQL command.

Compact and repair your access database online from ASP code. This is example code of how this can be done.

The purpose of this article is to show how to get records from an html form and submit that form to an ASP page. This ASP page will then use SQL to enter the records into the database.

Dropdowns or combo boxes are an excellent way to get input from a user. One of the biggest problems with user input is spelling and formatting. Here is how to use and populate dropdowns from a database.

Storing frequently used lookup data in a database is a great idea (e.g. order status codes, state names, etc.) that saves tremendous amounts of time in design and maintenance. However, retrieving that data from the database every time it is needed is very inefficient. This article describes how to use Application variables to cache frequently used lookup data in memory to achieve lightning fast access times.

An article on connecting to database via ASP using both DSN and DSN less connections. Explains uses of each. Learn using connection strings.

Allowing multiple choices of data elements enables people to customize views of your data and adds value to your applications. In this sample code, user inputted choice(s) are added to the basic sql statement to draw them from the db. Since the input from the dropdown menu comes through comma delimited it is simply written into the statement without modification. Two simple for next loops determine which elements are part of the record set and displays them accordingly.

The author writes "Recently I was asked to develop a web based report that would collect data from a database, format it in an HTML page and then print a certain number of rows on each page with a column header on each page. This solution solves the problem." Source code available for download.