Easysoft ODBC-Access Driver

Why do I get error "Failed to open MDB file"?

Article:
01005
Last Reviewed:
26th November 2009
Revision:
1

The Easysoft ODBC-Access Driver can open either a local or remote Access database file (.mdb or .accdb). The path to the database file is specified in the Easysoft ODBC-Access Driver data source in /etc/odbc.ini.

In the Easysoft ODBC-Access Driver data source, check the mdbfile attribute value.

Use ls to check that the mdbfile attribute in your data source specifies a valid path and that the directory is accessible.

If the ls command output contains "permission denied", contact your administrator. The directory containing the database file needs to be accessible (execute permission set) to you.

If the path is not valid, check with your administrator whether the database file is located on another machine. (The Easysoft ODBC-Access Driver can open a database file that is located on a Windows share.) If the database file is remote, use the mount command to check whether the share has been attached on the Easysoft ODBC-Access Driver machine. There should be an entry in the mount command output that corresponds with the directory specified with mdbfile. For example:

$ mount
/dev/sda3 on / type ext3 (rw,errors=remount-ro)
proc on /proc type proc (rw,noexec,nosuid,nodev)
/sys on /sys type sysfs (rw,noexec,nosuid,nodev)
.
.
.
//mywindowsmachine/myshare on /mnt/myshare type smbfs (rw)
$ grep mdbfile /etc/odbc.ini
mdbfile = /mnt/myshare/Northwind.mdb

If the mount command does not show the mount point specified in the mdbfile attribute, consult with your administrator. The share on which the database file is located needs to be mounted. (For more information, see the Easysoft ODBC-Access 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 Easysoft ODBC-Access Driver with a database file located in a Windows Vista share, this requirement equated to these Windows permissions:

PermissionsShared folder permissions
Change

Read

Modify

Read

Write

If the database file is located on Unix, the Easysoft ODBC-Access Driver will also return 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.)
Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)


Oracle is a registered trademark of Oracle Corporation and/or its affiliates.