Week 1 Questions

1. What version of Access will be used in our database examples?

   Access 2000 file format

2. What is an example of a use for the Dictionary object?

   To define key/item pairs as you might use in a database to show a relationship between a Primary Key and a List Item. An example might be an AutoNumber field used as a Primary Key (PK) and a list of Product Names used as a List Item.

3. Briefly describe how the Global.asa file is used.

   The global.asa is found directly under the root directory of your web server (which is often c:\inetput\wwwroot, or something similar, such as mine, which is c:\domains\mylastchoice.com\wwwroot). This file contains global variables as well as programming for the application object and session object that can be accessed by anyone using the site. This global.asa file is basically an ASP file that is processed whenever the web server is started.

4. Describe the difference between a virtual path and a physical path.

   The web root (ie. c:\domains\mylastchoice.com\wwwroot\) is the location from which all other virtual paths (ie. http://www.somesite.com/db/database.mdb -- a DataBase file -- an Access database file) are designated. The web server takes care of translating incoming URLs to the actual physical path so that it can deliver files and other resources.

5. Write the ASP command to display the physical path of a web root.

   Response.Write(Server.MapPath("/"))