The Access ODBC driver documentation.)
If the database file is on a Windows share, the user specified when mounting the share needs to have read
, write
, create
, and delete
permissions for the share. When testing the Access ODBC driver with a database file located in a Windows share, this requirement equated to these Windows permissions:
Permissions | Shared folder permissions |
---|---|
Change
|
Modify
|
If the database file is located on Linux or UNIX, the Access ODBC driver also returns a "Failed to open MDB file" if:
read
access to a local database file.
–Or–
The user specified by the smbuser
attribute only has read
access to a database file located on a Samba share.
readonly
attribute in the data source is set to yes
. (Change this attributes value to no
and try again.)