There isn’t enough disk space or memory when trying to update a table

Posted on by Jordansphere

OS: Windows 7

Software: MS Access 2003

When trying to change the column in MS Accees 2003 from Currency to Number we received the error : “There isn’t enough disk space or memory”

Looking in the table there are 350, 000 records – which makes sense.

To fix this we need to edit the registry. Go to START -> Run -> Type “Regedit” -> Go to “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0” -> Right click MaxLocksPerFile, select Decimal and increase the value data. I used 200,000.