php access的问题

$conn = @new COM("ADODB.Connection") or die ("ADO连接失败!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("php.mdb");
$conn->Open($connstr);

$connid=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC);
$sql="insert into wb_user(name,aaa,sex) values('22','33','4')";
$result=odbc_exec($connid,$sql);

if($result) echo "添加成功";
else echo "失败";

/////
问题$connid=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC);//这句话和上面$conn->Open($connstr);有没有冲突？干啥用的，还有就是执行后怎么全部关闭，比如$conn->Close();//关闭以便释放内存

什么问题

具体插入操作方案（先试试）：

<?

//链接库 $conn=new com("adodb.connection");  $connstr="driver={microsoft access driver (*.mdb)}; dbq=". realpath("db1.mdb"); $conn->open($connstr);    //执行

//接受数值

$username=$_post["username"]; $nian=$_post["nian"];

$rs=new com("adodb.recordset")or die('can not start active x data objects');

$sql="insert into yuyue(username,nian) values ( '$username','$nian')";

$conn->execute($sql);

?>