Hi, I want to connect to an MS Access database without using an ODBC. Can someone help me? I have been researching this for a while now and haven't found anything that works. Maybe it's just me. Thanks.

I dont think there is anything that works for connecting ms access without using odbc
while there are options available to connect mysql, oracle and ms sql server dbs

mysql - mysql_connect()
oracle - ocilogon()
ms sql server - mssql_connect()

using format like for example
$db = mysql_connect("localhost", "root", "password");
mysql_select_db("mydb",$db);
$result = mysql_query("select * from employees",$db);

there dont seem to be one available to connect ms access
however there is one product "php lens" which provides "adodb.inc.php"
using this "adodb.inc.php" you can connect to ms access
the format of which is

include("adodb.inc.php");
$db = newadoconnection('access');
$db->connect("localhost", "root", "password", "my_access_db");

regards
shivanna

Thank you for your help do you know anything about the other connection you were talking about? I found one that seems to connect, but then I don't know the syntax or how to write the code to work with it.

I have not used adodb.php.inc exactly
You can find this at [[http:// adodb . sourceforge . net / # download]]
Have a look, You should be able to use it