Can't add security object from another server

[rhyno2k]

Hi,


I have a PHP script (on IIS 6) that needs to connect to an Access database (.mdb) on a different network server. I'm trying to connect to it via ODBC but keep getting the same error:

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLConnect in D:\Web\Sites\mysite\partsearch.php on line 52

I'm assuming this is a permissions issue...

I can browse to the .mdb file fine from the web server. I cannot add "WEBSERV\IUSR_WEBSERV" to the Security tab of the database folder -- it only will let me select accounts from the domain controller . However, even when I assign "Everyone" Full Control over the folder storing the database, I still get the above error in my PHP script.

If I copy the .mdb file locally on the web server, I can connect fine... but the .mdb needs to reside on the file server!

Any ideas on how I can get this working?
Why can't I access the web server computer object in "Select Users, Computers, or Groups"?


Thanks,
--RHYNO

 

[rhyno2k]

Anyone have any ideas?