Microsoft JET Database Engine error '80004005' Not enough space on temporary disk. |
Make sure that IUSR_machinename has read/write access to the temp directory, and the folder where the MDB file is located. You may also try compacting and reparing the database (to see how to do this from code, without having to download the database file and open it within Access, see
Article #2190). Make sure you are using JET/OLE-DB drivers to connect to the database, not native/ODBC (see
Article #2126).
If your table is large, you may need to increase the value for MaxLocksPerFile. You can do this through the registry:
HKEY_LOCAL_MACHINE\Software\Microsoft\JET\4.0 \Engines\Jet 4.0\MaxLocksPerFile |
If you don't have direct access to the machine's registry, you can also try editing this programmatically:
| Conn.Properties("JET OLEDB:Max Locks Per File") = n |
A safe value for n is probably double the number of rows in the largest table you are trying to modify when you receive this error.