Very welcome to this demo
Before you can run the demo on your IIS/PWS you need to create an
ODBC datasource on your machine and connect it to the included
Access Database test.mdb.
You have to use the Datasourcename (DSN): test
(If you use another DSN you need to modify the file ute.inc)
Once this is done you can start exploring some tables you might know
from the Northwind Access Demo Database:
In all above links the primary key fields will be automatically detected.
There are cases where this automatism is not wanted or doesn't work:
In all my tests with MS Access 97 and MS SQL Server 7.0 the
KEYCOLUMN property of the field object was not supported by the provider
(driver). I have added some code that identifies auto-increment fields as
primary key fields (as they are mostly primary keys).
If the "auto primary key detection" is not wanted you have to set the primary keys
by yourself. Well, this is how it works:
Enjoy !
tom@wellige.com
www.wellige.com