Database driven, dynamic content delivery: providing and managing access to online resources using Microsoft Access and Active Server Pages

As the number of online journals, databases, and indexing and abstracting services continues to grow on the Internet, it is important that libraries find efficient ways to manage and provide access to these resources. By utilizing database driven dynamic content delivery technology, library Web administrators can obtain numerous management benefits over a static HTML site. Presents an efficient model using Microsoft Access database software and an ASP (Active Server Pages) scripting method to manage and deliver the University of Arkansas Library’s electronic subscription services. Benefits include centralized data management and maintenance, streamlined administration, customized content, and improved response to simultaneous user access. Web server platforms, programming skill levels, and data storage limitations are also discussed. A single MS Access database utilizing two relational tables is used as an example to demonstrate the underlying database organization.