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
Protecting Data in SQL Statements
Protecting Data in SQL Statements - Test Script
- Connecting to an MS Access database file requires no ODBC setting.
- Inserting data to MS Access file requires "write" permission to file for the Internet Guest account.
- MS Access string and date values need to be quoted. The quoting character must be protected if it
appears in the value.
- MS Access has many reserved word. If you use them as table names or field names, you must enclose
them in "".
Table of Contents
About This Book
ASP (Active Server Pages) Introduction
IIS (Internet Information Services) 5.0
MS Script Debugger
ASP Built-in Run-time Objects
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
PDF Printing Version