Why do I get error "[Easysoft ODBC]General error: Unable to open working file for LONGVARCHAR field" when using the Access ODBC driver?

The Access ODBC driver can't create temporary files in the current working directory of the process using the ODBC driver (the default location). This often occurs when using the driver with a daemon process such as Apache. The solution is to provide the driver with a location where it is able to create temporary working files. Specify a directory that has sufficient free space and create privileges for the user the driver runs as.

To set the working directory, add the following lines to the Access ODBC driver DSN in odbc.ini:

work_dir_path=/tmp
blob_path=/tmp

where /tmp in this example is the location for temporary files.