Why do I get error "Failed to open MDB file" when using the Access ODBC driver?
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:
- The user running the application that is connecting to the data source only has
readaccess to a local database file.–Or–
The user specified by the
smbuserattribute only hasreadaccess to a database file located on a Samba share. - The
readonlyattribute in the data source is set toyes. (Change this attributes value tonoand try again.)