Re: ADO Connection Problems

* Thus wrote Joe Mack (joe.mack@g-k-m.com): > I am getting no error messages or anything, but when I browse the database, > my changes are not being posted. Here is an example of what I am trying to > do. Hopefully, I am just missing a step along the way. ensure that your error_reporting and display errors is on. > > $dbFile = '\\\\SERVER\\FOLDER\\BackEnd.mdb'; Inside single quotes the \\ does NOT get translated to \ > $conn = new COM('ADODB.Connection'); > $conn->Open("DRIVER=Microsoft Access Driver (*.mdb);DBQ=$dbFile"); > $cmd = new COM('ADODB.Command'); > $cmd->ActiveConnection = $conn; > $cmd->CommandText = "UPDATE TABLE1 SET FIELD1 = '$parm1' WHERE FIELD2 = > '$parm2';"; ensure this sql statement is proper. try echoing it out and seeing if it is correct (particularly the $parm2) > $cmd->Prepared = TRUE; > $RSet = $cmd->Execute(); > > Any assistance anyone can offer would be greatly appreciated. Thank you. I'm not familiar with ADO and php so i can't give advice on that end. Curt -- "I used to think I was indecisive, but now I'm not so sure."