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
In the Easysoft ODBC-Access Driver data source, check the
mdbfile attribute value.
ls to check that the
mdbfile attribute in your data source specifies a valid path and that the directory is accessible.
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:
|Permissions||Shared folder permissions|
If the database file is located on Unix, the Easysoft ODBC-Access Driver will also return a "Failed to open MDB file" if:
The user specified by the
smbuser attribute only has read access to a database file located on a Samba share.
readonlyattribute in the data source is set to
yes. (Change this attributes value to no and try again.)
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.