ASP Tutorials - Herong's Tutorial Examples

∟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

Takeaways:

• 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

 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

 Full Version in PDF/EPUB

Working with MS Access Database - Updated in 2019, by Dr. Herong Yang