Applies to:
Foxtrot Classic, Foxtrot Legacy — all versions

Summary:
When attempting to import an Access table into Foxtrot, you receive a warning:
The specified file does not exist or is inaccessible
Followed by the path of the file.

Resolution:
We recommend the following solutions to the resolve the issue:

    • Ensure the user has read, write, and modify permissions to the Local Setup Path

 

The Local Setup Path can be found in the Configure tab of the Foxtrot Admin Center. This path is what Foxtrot uses to store and locate all of your configuration settings. You can determine if you have the proper permission level by navigating out to this path, and checking the Security property.

    • Ensure the Enhanced Import Wizard is enabled

 

The Enhanced Import Wizard is necessary in order to import any special file types, such as Excel or Access. For more information on how to enable this feature, please reference our Support article, titled Unsupported Database Type. You will need read, write, and modify permissions to the Local Setup Path (above) in order to enable this feature.

    • Ensure the user has the proper permissions level to the ODBC registry key

 

ODBC stands for Open Database Connectivity, and is Foxtrot’s way of connecting to your data files. The ODBC interface makes it possible for applications to access data form a variety of database management systems. ODBC is a low-level, high-performance interface that is designed specifically for relational data stores. Foxtrot users need full control to this registry key. To set this permission level:

1. Click on your Start Menu and type REGEDIT.EXE and press enter
2. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC
3. Right click on the ODBC folder and allow the specific user, or the group of users, to have Full Control to this key

    • Verify the machine’s drivers are up to date

 

If your machine has never had Microsoft Office 10 installed, then it is possible that a driver needs to be installed or updated. You can download the Microsoft Access Database Engine at the following link:
http://www.microsoft.com/en-us/download/details.aspx?id=13255

Last Modified 10/23/2014