·  PHP – DB – Access – Create

 

- Info:

  - This tutorial shows how to create Access DB which will be used in following tutorials.

 

- Create fields:

  - Start – Office Applications – Microsoft Access – Blank Access Data Base – OK

  - Save in: D:\Temp\PHP – File name: guestbook.mdb – Create

  - DLC on "Create Table in desing view"

  - Field Name    Data Type

    ID          Autonumber

    Name        Text

    Age        Number

    Born        Date/Time

  - RC on ID_no – Primary key – File – Save – Table name: People

 

- Enter data:

  - Close – DLC on People

  - ID  Name  Age

    1  John  50

    2  Maria  34

  - File – Save – Close

 

- Create DSN:    

  - Start – Setttings – Control Panel – Administrative Tools– Data Sources (ODBC) – System DSN – Add

  - Microsoft Access Driver (*.mdb) – Finish – Data Source Name: guestbook

  - Select – D:\Temp\PHP\guestbook.mdb

  - OK – OK – OK