Access: Not enough space on temporary disk
Add the following syntax to your query/application code .
DBEngine.SetOption dbMaxLocksPerFile, 65000
technet information on Maxlockfiles
Error :
Microsoft OLE DB Provider for ODBC Drivers error ’8007000e’ [Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary disk.
