If you're here you most likely want to know how to use Microsoft Access
to create a database for use with ASP. This article assumes you at least
have some knowledge of what a database is and consists of..
The first step to creating an Access database is opening up Access. Then
you should see this screen.
Select Blank Access Database and click ok. Then you will
a screen to save the database. Just browse to the folder to save in and
type in the name you want and click OK.
Now
you should see a window with a bunch of buttons and options. Double Click
on "Create New table in design view" Then you have a spread
sheet type window. The first column is where the names of the fields will
go, just type in th name for the field. The second column is the type
of data that will go into the field, (i.e. text,numbers,date/time) Text
only allows for up to 255 characters so if you need more room, choose
Memo . Auto number automatically incriments from 1 and
up when you add a new row, which is good for when you give an ID to each
row/record. The description field doesn't matter since you can't do anything
with it in ASP.
Now close the design window. You will be prompted to save the table,
click yes and type in a name for the table. Then when you get back to
the main window, you should see a new icon in the right-hand side with
the name you gave the table. Double click it and you will see an Excel
type window. This is the actual table view. From here you can start entering
your data. When you get to the end of the row, a new one will appear which
will be your second and so on record.
Now this should get you started. If you don't know how to use ASP to
access a database, check out my: ASP Database Tutorial.
