The driving force behind Active Server technologies is data access. In order to develop a truly dynamic web site developers need to allow users to access data on demand. Luckily, with Microsoft's Active Server Pages, this is exceedingly easy to do. This article for ASP beginners details how to connect to a SQL Server 7.0 database using ActiveX Data Object (ADO) and Open Database Connectivity (ODBC).

This article shows how to generate random records from the database. Also explains how to generate random numbers. Sample Database and Code available for download.

This short tutorial explains how to to upload a text file and load it into your database using ASP. It uses a sample of the space-delimited file for an example.

Learn how to search and sort the records through the database. Step by step tutorial with Sample code and database available for download. Online demo also available.

In depth article on showing records in a page by page fashion with 'first page','next','back' and 'last page' links at the bottom to navigate through the records. Sample code and database available for download. Online demo also available.

You can connect to an Access database within an ASP page with different methods. This article will help you to create a System Data Source Name (DSN) for an Access database on your local machine.

Multiple level select boxes tackled with hierarchical data! This sample illustrates the concept using a hierarchy consisting of geographical region, country, and state data. The code expects a system DSN by name "Hierarchy" and accesses the database using the user id "sa" with a blank password. The database is created in SQL Server 7.0.

Sample implementation (source code)illustrating how to implement a "Suggestion Box" style form using ASP and MS Access. Easily installed, and customized.

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

This article explains a solution on how to increase the performance of your ASP pages that rely on gathering data through several different Recordsets. Specially, using a nifty feature of the ADO Recordset object, Multiple Recordsets, you can store multiple SQL query results in one Recordset object, requiring fewer communications with the database.