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.