Dreamweaver MX 2004 Do ASP Program (2) Build database

dreamweaver| Program | data | database

1, first confirmed that the site root directory has a special database storage directory, such as E:\myweb the following Databases folder (there is OK, no new). I'm using Microsoft Access 2003.

Then open Microsoft Access, "file"---"new", then select an empty database , and in the pop-up dialog box, select the store path and name it.

2, in the new database "Create a table using the designer", pop-up "Table 1" in the design of your related fields, pay attention to their "data type", but also important: field ID, type AutoNumber, and select it as the primary key .

3, after the design of "Table 1" , directly close the window, in the pop-up dialog box click "Yes" to save "Table 1", and renamed to user.

At this point you need to mention that the setting of the field ID that you just emphasized is necessary, otherwise the following dialog box will appear after the save, and the effect is to set the type to be the key field for AutoNumber.

4, this time the database table user has been established.

5, double-click the database table user, small Tim Try, in the pop-up user table input related content. Close save.

At this point the database, table, field, the establishment of the save work finished. Here we start using Dreamweaver to manipulate the MDB file.