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.