Before commencing this tutorial, i have to say that for the ODBC setup section,
I used the work
of Leo West. His page
on ODBC setup and interfacing with Ms-SQL server was most usefull to my original work project...
Until my boss changed the project specs to make the database to be MS-Access, instead of MySQL.
If you need to find out more information about SQL, go
Summary of Contents
Creating an Access database
Setting up an ODBC Connection
Interfacing with database
I am going to assume a *little* experience in databases. Having said that, I'm
really only hoping that you know how to create a database and insert tables
into that database.
Apache/Web server of some kind
PHP 3.0 (at least)
Ms-Access (Version 97+)
Wordpad for editing PHP
Windows 9x+ of some working *grin* description
Files used in this tutorial (remove .sid extension to make functional)
I have given directions on exactly how to make the above files. But just in case
my directions aren't 100% correct, you can download a working copy of the relevant
Throughout this tutorial, i have assumed that the person who will interface with
the database will have full read and write priveleges to the database. It is best
in any circumstance to make sure you have read and write priveleges to the
database. Having said that, please, please, please try out these techniques on a
sample database located on a 'local' machine. I know first hand the trouble caused
if you screw up a company database upon which most of the company relies.