Problem with using MS Access Database

[Rheves]

This is the connection bit that is causing me problems:

 

include('C:\\Inetpub\\Websites\\nwccsd_com\\adodb\\adodb.inc.php');
    $db = ADONewConnection('access');
    $dsn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\\Inetpub\\Websites\\nwccsd_com\\database\\Users.mdb;Uid=;Pwd=*****;"; (Password changed)
    $db->Connect($dsn);

 

When I try to use this is the error I get:

 

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x1748 Thread 0x1924 DBC 0x3d6e024 Jet'., SQL state S1000 in SQLConnect in C:\Inetpub\Websites\nwccsd_com\adodb\drivers\adodb-odbc.inc.php on line 60

 

Googling has told me that the biggest reason for this is that the physical path to the database is not correct. The path I have is correct and the folder the database is in and the adodb folder have been set to have Full Control.

 

Can anyone help me out here?

[psobolik]

[Guessing that you are using IIS] Is it possible that the database file is not readable by the IIS service user (probably IUSR_<computer name>)?