Working with MS Access Database

This chapter provides tutorial notes and example codes on using MS Access database. Topics include connecting to MS Access database file without using ODBC; persisting data to database; retrieving data from database; protecting data in SQL statements.

Connecting ASP Pages to MS Access Databases

"hello_access.asp" - MS Access Example

Persisting Data to MS Access Databases

Running "insert_access.asp"

Protecting Data in SQL Statements

Protecting Data in SQL Statements - Test Script

Conclusions:

Table of Contents

 About This Book

 ASP (Active Server Pages) Introduction

 IIS (Internet Information Services) 5.0

 MS Script Debugger

 VBScript Language

 ASP Built-in Run-time Objects

 ASP Session

 Creating and Managing Cookies

 Managing Sessions with and without Cookies

 scrrun.dll - Scripting Runtime DLL

 Managing Response Header Lines

 Calculation Speed and Response Time

 ADO (ActiveX Data Object) DLL

Working with MS Access Database

 Guest Book Application Example

 References

 PDF Printing Version