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
When it is not necessary to make a decision, it is necessary not to
make a decision.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to