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

Read

 Modify

Read

Write

If the database file is located on Linux or UNIX, the Access ODBC driver also returns a "Failed to open MDB file" if:

  1. The user running the application that is connecting to the data source only has 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.

  2. The readonly attribute in the data source is set to yes. (Change this attributes value to no and try again.)