MS Access ADO Fallover

[killahara]

I've been trying to connect to a simple access database using php (access was not my idea) but keep falling over at Execute(). Is there any way to get the output of why this is falling over? I have adodb installed on my server and test.mdb is sitting on the c:\ drive.

 

Any help is greatly appreciated!

 

D

 

<?php

include("adodb.inc.php");

$database_type = "access";

$db = NewADOConnection("$database_type");

$dsn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\\test.mdb;Uid=;Pwd=;";

$db->Connect($dsn);

$sql = "SELECT * FROM tbl1";

$rs = &$db->Execute($sql); //Fall at this point

$rs->Close();

$db->Close();

echo "Ran code sucessfully";

?>