php 操作access

<?php
session_start();
error_reporting(E_ALL & ~ E_NOTICE);

//读取mdb数据库例程
$dbname = "a.mdb";
$conn = new com("adodb.connection");          //实例化adodb
$connstr="driver={microsoft access driver (*.mdb)}; dbq=". realpath($dbname);     //连接数据库路径
$conn->open($connstr);                 //打开数据库

$rs=new com("adodb.recordset");               //实例化adodb
$sql="select `b1` from `b`";      //查询
$rs->open($sql,$conn,1,3);
$a1 = $rs->fields[0]->value;

$aid8 = $_GET["aid"];
if ($aid8)
{
    $dbnameb = "b.mdb";
    $connb = new com("adodb.connection");          //实例化adodb
    $connstrb="driver={microsoft access driver (*.mdb)}; dbq=". realpath($dbnameb);     //连接数据库路径
    $connb->open($connstrb);                 //打开数据库

    $rsb=new com("adodb.recordset");               //实例化adodb
    #$sqlb="update `b` set `b1`='{$a1}'"; // update
    $sqlb="insert into `b`(b1,b2) values('{$a1}', '234')";   // insert
    
    $connb->execute($sqlb);

    echo "已成功把A数据库的a1 字段数据导入 B数据库！";
}

?>


<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta http-equiv="Pragma" content="no-cache">
<meta http-equiv="Cache-Control" content="no-cache">
<meta http-equiv="Expires" content="0">
<meta name="author" content="">

<title>Access数据库操作</title>
<style type="text/css">
<!--
body,td,th {
    font-size: 14px;
}
-->
</style>

</HEAD>
<BODY leftmargin="20" topmargin="20" marginwidth="0" marginheight="0">
<form name="azbce8" action="?aid=azbnb" method="post">
<table width="500" border="0" align="center" cellpadding="5" cellspacing="5" style="border:1px solid #0099CC;">
  <tr>
    <td height="25">这里是A数据库</td>
  </tr>
  <tr>
    <td>字段a1 内容：<font color="#FF0000"><?php echo $a1 ?></font></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td align="center"><input name="nb" type="submit" value="按钮A转B" /></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>

</form>
</body>
</html>

http://p6.zbjimg.com/task/2012-05/17/1706749/4fb4ee1c680dc.rar