Overview
Export Error

SCOPE    -    SDTM, SDTT
TYPE    -    issue document


Description
When the program encounters an error during the export process, it means that the data was processed, but the results cannot be written to the hard drive.

Common reasons include...
  • the destination directory does not exist (more likely)
  • the export file is already open in Excel (more likely)
  • you lack write permission to the destination directory (less likely)

To check that the destination directory exists...
  • open the PREFERENCES dialog
  • verify that the DEST directory exists
  • if not, select another directory

To check that the file is not already open...
  • close down Excel
  • open Task Manager (left-click on task bar)
  • verify no crashed Excel processes are running

To check that you have write permission to the destination directory...
  • open the PREFERENCES dialog
  • change the DEST directory to C:\
         - or any non-system directory


Notes
There are several reasons that you may not have write permission to the destination directory, including (1) not logged in with administrator privilege (2) no write permission to the "Program Files" directory. Another possibility is that either Microsoft Access or the application itself does not have write permission (due to firewall rules, for example). Permission issues are more likely with new machines using the initial factory settings.

You might think that you have the necessary write permissions, but that may not be the case. There is a difference between an account that has been assigned administrator privileges (any # of accounts), and the administrator account (only one such account). User accounts with administrator privileges can have other restrictions, which is less likely with the administrator account. It is generally not recommeded to use the administrator account as your main user account, for security reasons.

The easiest solution for permission related errors is to change the destination directory. The more permanent solution requires changing the permissions for the application or the current user. For the application, you may have to change firewall rules. For the current user, you may have to change either "C:\Program Files\" or "C:\Program Files\[app-name]" to full write permission.
Page Updated: February 17, 2013