Permissions error trying to open MDB file with ODBC

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. 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 is on a computer running WinXP
Pro.

Any suggestions will be greatly appreciated.

Thanks.

.

Relevant Pages

  • How to use SQL "LIMIT" keyword against an MDB file
    ... I'm trying to adapt a PHP script that was written to use MySQL, ... that it will work with an MSAccess MDB file. ... using ODBC functions to access an MDB file? ...
    (comp.lang.php)
  • Re: Permissions error trying to open MDB file with ODBC
    ... I have set the sharing/security on the folder where the MDB file ... one with WinXP Pro using IIS and the other Win2K ... Do you use an UNC path or a mapped drive? ... What I have not tried is a DSN; I really don't want to do it that ...
    (comp.lang.php)
  • Re: Permissions error trying to open MDB file with ODBC
    ... I have set the sharing/security on the folder where the MDB file is ... one with WinXP Pro using IIS and the other Win2K ... the MDB file is on a computer running WinXP ... Do you use an UNC path or a mapped drive? ...
    (comp.lang.php)
  • Re: Permissions error trying to open MDB file with ODBC
    ... I have set the sharing/security on the folder where the MDB file is ... server set-ups: one with WinXP Pro using IIS and the other Win2K ... the MDB file is on a computer running WinXP ...
    (comp.lang.php)
  • Re: Permissions error trying to open MDB file with ODBC
    ... I have set the sharing/security on the folder where the MDB file is to ... move the MDB file to the server! ... one with WinXP Pro using IIS and the other Win2K using ... the MDB file is on a computer running WinXP ...
    (comp.lang.php)