Here is sample code on a connection. Tested on WinXP, works fine.
-
<?
-
// url to database file
-
$db = 'C:\\Program Files\\Microsoft Office\\Office\\Samples\\Northwind.mdb';
-
-
// adodb connection
-
$conn = new COM('ADODB.Connection');
-
$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db");
-
-
// sql code
-
$sql = 'SELECT ProductName, QuantityPerUnit, UnitPrice
-
FROM Products
-
ORDER BY ProductName';
-
$rs = $conn->Execute($sql);
-
-
// html
-
?>
-
<table>
-
<tr>
-
<th>Product Name</th>
-
<th>Quantity Per Unit</th>
-
<th>Unit Price</th>
-
</tr>
-
<? while (!$rs->EOF): ?>
-
<tr>
-
<td><?= $rs->Fields['ProductName']->Value ?></td>
-
<td><?= $rs->Fields['QuantityPerUnit']->Value ?></td>
-
<td><?= $rs->Fields['UnitPrice']->Value ?></td>
-
</tr>
-
<? $rs->MoveNext() ?>
-
<? endwhile ?>
-
</table>
-
<?
-
$rs->Close();
-
$conn->Close();
-
?>
-
