> Hi guys, got a tricky question here and I know I will probably get
> flamed for asking it here but here goes!
>
> My boss wants me to put a large Access database onto the net so that
> people can query it both from the company and from the outside and he
> wants to be able to have the database up to date and also easy to
> change.
>
> As far as I can see that leaves me with only Active Server Pages in
> which to access this database or am I wrong?
You can use PHP, of course. ODBC or COM.
Here is an example some program automatically created that shows how to
connect to and query an Access database:
$conn = new COM("ADODB.Connection") or die("Cannot start ADO");
$conn->Open("Driver={Microsoft Access Driver (*.mdb)};Dbq="
.realpath("datab/test.mdb"). ";Password=;");
$SQL="SELECT COUNT(*) AS Count FROM test";
$countx = 0;
$rs = $conn->Execute("$SQL");
while (!$rs->EOF) {
$countx = $rs->Fields("Count");
---John Holmes...
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
