Re: problem in PHP with ADODB connection, Microsoft JET Database

On Wednesday 19 February 2003 10:09, pei_world wrote: > when I try to connection to the access file using Microsoft Jet Engine. it > come up with following error! > $result = $conn->Execute($query) <----error line > I check the table is exists,and the query should be correct. *should* be correct or IS correct? There's quite a difference. > ---------------------------------------------------------- > Warning: Invoke() failed: Exception occurred. Source: Microsoft JET > Database Engine Description: Syntax error in FROM clause. > ----------------------------------------------------------------- The error is quite explicit: "Syntax error in FROM clause" So unless the Jet Engine is lying or is buggy then you have an incorrectly formed query. > can anyone help me? Nobody can help you unless you post your query. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db ------------------------------------------ /* When it is not necessary to make a decision, it is necessary not to make a decision. */