Hi everyone,
I'm trying to connect an Access database that is not on the same server as
the web server. All the servers are Windows NT 4, the web server is IIS4,
and I'm using PHP4. Whenever I try to query the database, it returns:
Warning: SQL error: [Microsoft][ODBC Microsoft Access 97 Driver] The
Microsoft Jet database engine cannot open the file 'SIDSC.MDB'. It is
already opened exclusively by another user, or you need permission to view
its data., SQL state S1000 inSQLExecDirect
I've checked that the database is not opened by anyone else. I've also tried
creating a new database on the web server and creating links to the tables
in Access, but I still get the same error. The remote database has read
permissions for the 'Everyone' group, so does the entire directory path, and
the share.
Can anyone help?
Many thanks,
Dan
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
