Access DB & PHP

Hi guys, I have a client who insists on using PHP and an Access database. He describes a problem with the access databases becoming locked when a user clicks 'stop' in their browser whilst downloading the page (and I have to stop the IIS server to release it). I have absolutely no experience with PHP/Access connections, so I thought I'd ding it along and see if the elite PHP programmers of the world can pick up an error in his code. > > I connect like this: > $conn = new COM ('ADODB.Connection'); > $conn->Open ("Provider=Microsoft.Jet.OLEDB.4.0; Data > Source='c:\\home\\westir\\data\\libcat.mdb'"); > $sql = "SELECT * FROM tbl_name "; > $result = $conn->Execute($sql); > > // deal with the database generated information > > $result->Close() > $conn->Close Is there a better way to do this? Best Regards Bob Irwin Server Admin & Web Programmer Planet Netcom