when I try to connection to the access file using Microsoft Jet Engine. it
come up with following error!
can anyone help me?
$conn = new COM("ADODB.Connection");
$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$database");
$query = "SELECT * FROM user";
$result = $conn->Execute($query) or die("fail to connection to the
database!");
if ($result->RecordCount()!=-1){
//do something
}
----------------------------------------------------------
Warning: Invoke() failed: Exception occurred. Source: Microsoft JET Database
Engine Description: Syntax error in FROM clause.
-----------------------------------------------------------------
thx
--
Sincerely your;
pei_world ( .::IT::. )
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
