I found the following code on the internet. I'd like to know that what I need to do, if I want to use the actually Access file with out the DSN, how to use the Microsoft Jet? thx ---------------------- code -------------------------------- include("adodb.inc.php"); $db = NewADOConnection('mysql'); $db->Connect("localhost", "root", "password", "mydb"); $result = $db->Execute("SELECT * FROM employees"); if ($result === false) die("failed"); while (!$result->EOF) { for ($i=0, $max=$result->FieldCount(); $i < $max; $i++) print $result->fields[$i].' '; $result->MoveNext(); print "<br>\n"; } -------------------------------------------------------------- -- Sincerely your; pei_world ( .::IT::. ) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php