Using ODBC in a PHP script, I'm trying to read an MS Access MDB file
that resides on another computer on my LAN. I'm getting the 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 ...
The file is NOT already opened exclusively (or in any other manner) by
another user.
I have set every "permission" that I can think of to allow access to
the MDB file.
I have set the sharing/security on the folder where the MDB file is to
allow "everyone" full control.
One thing that showed up on a Google search taked about setting the
"default open mode" in the database itself to "shared". I've done that
- it made no difference.
Another thread I found dealt with this exact same problem but the
issue was never resolved - the guy said he was going to give up and
move the MDB file to the server!
Surely there must be a way around this.
If it matters, I'm using PHP 5.2.
It's a DSN-less connection to the database.
I've tried it on two different server set-ups: one with WinXP Pro
using IIS and the other Win2K using Apache. In both cases, the MDB
file (which is an Access2K file) is on a computer running WinXP Pro.
Any suggestions will be greatly appreciated.
Thanks.
