This may be more of an ODBC question than a PHP question, but the expertise certainly seems to be here to give a quick assist. From the subject line, you've probably gathered that I'm stuck trying to connect to an Access2000 database on a machine other than the web server.
The PHP script works fine as long as the DB is on the web server machine. When I move the DB to the remote machine and create a DSN using the UNC path, the connection sets up with no problem if I use the browser on the web server machine. If, however, I go to another client machine the MS Access driver returns an error indicating that either I don't have sufficient permissions, or that the DB has been opened exclusively by another user.
Sounds like a permissions issue, right? Probably is, but I'll be damned if I can figure it out. Something with the system.mdw file perhaps? I've tried setting up the DSN both with and without a system database. I haven't set up any security for the database in question.
Platform is MS PWS running on an NT4.0 workstation machine with PHP 4.0 (small departmental intranet site).
Anyone out there want to help me kickstart this one?
John
