PHPBuilder - Interfacing with MS Access Page 2



RSS Twitter
Articles Databases

Interfacing with MS Access - Page 2

by: Siddharth Venkatesan
|
July 30, 2000

Creating An Access Database To Use

Generally when you start up access, it gives you the option of opening an existing database or creating a new one. For the purpose of this tutorial, im going to assume you are going to create a new database.
Start up Access. If Access is already running, close all other Access databases currently open. This is just to make the tutorial a bit easier. Now, create a new Access Database. You can call this database whatever you like. Just make sure you remember the name and the location you save it to, as you will need it later to create the ODBC connection. Into this database create the table 'People'. Into people, add the fields of name and specific types as follows:
Field Name
Field Type
Index
Auto Number
FirstName
Text
LastName
Text
PhoneNumber
Number
You dont need to populate the table as we will do that later on.

« Previous Page
1
|
2
|
3
|
4
|
5
Next Page »

Comment and Contribute

Your comment has been submitted and is pending approval.

Author:
Siddharth Venkatesan

Comment:



Comment:

(Maximum characters: 1200). You have characters left.