Databases Reference
In-Depth Information
Fortunes : Table
Field Name
Data Type
Description
Fortune_ID
AutoNumber
Tex t
Fortune
Field Properties
General
Lookup
Long Integer
Field Size
New Values
Increment
Format
Caption
Indexed
Yes (No Duplicates)
Exhibit 34-2. The
Fortunes
table schema.
tions. Fortunately, should you decide to put this project together on your
own personal computer, you can just download the Microsoft Access data-
base. To give you an appreciation of what was done and how, we'll briefly
outline the database's schema, and how we used and configured the con-
trol panel ODBC applet.
The fortune database has only one table. This table has two fields:
• a
Fortune_ID
, and
• a
Fortune
.
is a unique, self-generated autonumber that is indexed
and serves as the table's primary key. The
The
Fortune_ID
, as you might expect, is
a text entry of up to 200 characters that holds all the wise adages we'll be
delivering to the client. Exhibit 34-2 is a screen capture of the database
design view as it appears in Microsoft Access, and Exhibit 34-3 shows you
the datasheet view.
Fortune
We now need to decide where to place the Access database in the file
system. Because we intend to use our database from the web, We might be
inclined at first to move it to where all our other Web files are located. A
better solution, though, is to place the
.mdb
Access file in a directory
named
(or whatever name you choose) that resides
entirely elsewhere. This is a good practice in general, especially for secu-
rity reasons (we don't want someone downloading our database, do we?).
Internet Databases
Search WWH ::
Custom Search