Easysoft ODBC-Access Driver

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

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 share, this requirement equated to these Windows permissions:

Permissions	Shared 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

• Products
  • Easysoft ODBC-Access Driver

Knowledge Base Feedback

* Did this content help you?

Yes No Maybe

* Please select one option based on your first choice:

I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

Suggest new content or let us know how we can improve this content:

(* Required Fields)

• About Easysoft

• Contact Us
• About Us
• Clients
• Upgrade Offer
• Blog
• Careers

• Products

• ODBC Drivers
• JDBC Drivers
• Bridges and Gateways
• In Development

• Services

• Consultancy
• Training
• Custom Development

• Licensing

• Product Licenses
• Prices

• Support

• Support Home
• Solution Wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer Area
• Client Applications

• Legal

• Privacy Statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle® is a registered trademark of Oracle® Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
• 
•