An Overview of Database Access on
Using ASP and Microsoft Database Technology
Sheffield Hallam University 2003
Structure of Session
An Overview of Database Access Over the Web
1 (20 mins):
A. Introduction to Client Server technology on the web
B. Introduction to HTML, Scripting Languages ASP technology
C. An introduction to ASP
D. Getting acquainted with Microsoft Access databases
: Experimenting with HTML (20 mins)
: Experimenting with ASP (25 mins)
: Playing with the Shopping Cart e
Site (15 mins)
Structure of Presentation
Introduce ASP and Microsoft Database
3 Tiered Network architecture
Simulate working example of ASP
Demonstrate Shopping Cart e
Discuss areas for further study
What is Microsoft Access?
Microsoft’s economical, Small
Currently release is Access 2002 (XP)
Little brother to Microsoft SQL Server
end GUI building functions
Moderate performance, 100 max simultaneous
users, good enough for smaller e
Intuitive GUI, VBA programming, can build self
contained database applications
SQL Server is very popular
Similar functionality to Access
Many more advanced features e.g. stored
SQL suitable for larger scale e
i.e 1000’s simultaneous users
Well worth being familiar with it!
SQL Server 2000
What is ASP?
ASP stands for
Active Server Pages
Developed by Microsoft
Normally coded using VBScript
Language used to ‘script’ operations on the server
invisible to client machine
Highly popular, used by 1000’s Web sites e.g.
Enhances Web pages by adding dynamic content
What can ASP do (that HTML can’t)?
Interact with databases to read and write data
Read and write ‘cookies’ to a users computer
Track user activity within a Web site
Check user input (validation)
Talk to other applications on server e.g. Word
Talk to custom built applications on server
Send bulk email or automated email responses
Return dynamic HTML code back to the client
Read data from the end of a URL (called a query
What is ASP used for on Web?
Online mortgage, credit, loan applications
Sample of ASP code
dim req, copyright
copyright =" This sample program Copyright SHU, 2003"
if req = "search" then
Phase Test Marks
Students take phase tests on a regular basis
The tutor logs the marks for these tests on a
on an Database called
The course leader uses an ASP page to request
the mark of any student and a pass/ fail status
Phase Test Marks
Model of Client
(e.g. Microsoft IIS)
(e.g. Windows 2000)
ASP Code Walkthrough
ASP code is contained within
VBscript syntax almost identical to VB
ASP code reads
from URL to
ASP dynamically returns HTML via
ASP seamlessly connects to SQL database
side validation to check form data
Uses inline script e.g.
data directly into HTML code
Pushing the limits of ASP
Summary of Lecture
Introduced ASP, HTML and Access
Simulated how ASP can be used to retrieve
data from an SQL Server database
Explained ASP code in detail
Areas For Further Study
What are the pros and cons of using ASP?
How do alternatives compare e.g. JSP
How does the performance of ASP compare
why is there a difference?
How much of an improvement is ASP.net?
How much better is SQL Server 2000 than
In which business situations would you
choose SQL Server over Access?