open(provider=sqloledb; data source=$host;
initial catalog=$db; user id=$user; password=$password);$rs = $conn->execute($sql);  
$num_columns = $rs->fields->count();
echo $num_columns . \n;
for ($i=0; $i {
  $fld[$i] = $rs->fields($i);
}$rowcount = 0;
while (!$rs->eof)
{
  for ($i=0; $i   {
    echo $fld[$i]->value . \t;
  }
  echo \n;
  $rowcount++;        
  $rs->movenext();
}$rs->close();
$conn->close();$rs->release();
$conn->release();$rs = null;
$conn = null;
?>
php与access数据库连接的代码
$dbc=new com(adodb.connection);
$dbc.open(driver=microsoft access driver (*.mdb);dbq=c:\member.mdb);
$rs=$dbc->execute(select * from tablename);
$i=0;
while (!$rs->eof){
$i+=1
$fld0=$rs->field(0);
$fld1=$rs->field(1);
....
echo $fld0->value $fld1->value ....;
$rs->movenext();
}
$rs->close();
?>