I want to create a simple website that interfaces a small Access database with a Delphi program (CGI). I'm using D5 Professional.
I've got the CGI stuff ok (I have D2 code that handles CGI i/o without using any CGI components).
What I need is to figure out how to send SQL queries to the Access database?! I've created an ODBC alias for the .mdb file, but now what?! DataSource, Database, and Table components are confusing me.
As this is my first real database app, please give me step-by-step directions to open the database and run a query against some of the tables.
Thanks in advance :-) I'll boost the points if it's harder than [I think] it should be.