<p><a href="http://wincert.net/wp-content/uploads/2015/01/microsoft-office-2.jpg"><img class="alignnone size-full wp-image-559" src="http://wincert.net/wp-content/uploads/2015/01/microsoft-office-2.jpg" alt="microsoft office box" width="720" height="340" /></a></p>
<p>When you perform an operation on an Access 2007 table, you might experience the following error:</p>
<p><strong>Microsoft Office Access can&#8217;t change the data type. There isn&#8217;t enough disk space or memory.</strong></p>
<p><strong>Errors were encountered during the save operation. Data types were not changed. Properties were not updated.</strong></p>
<p>You can see the screenshot of the problem below:</p>
<p><!--more--></p>
<p><img class=" size-full wp-image-104" src="http://wincert.net/wp-content/uploads/2010/03/office_access_cant_change_data.PNG" alt="" width="606" height="270" border="0" /></p>
<p>This error happens when you have exceeded the maximum number of columns allowed in a table, or the maximum number of locks for a single file. Therefore, you have to increase the maximum number of locks per file by editing a registry entry for the local computer.</p>
<p><span style="text-decoration: underline;">However, this it is not a recommended solution from Microsoft and you are editing registry at your own risk.</span></p>
<p>Open the registry by typing &#8216;Regedit&#8217; in the Run Window. <strong>Win+R | Regedit | Enter</strong></p>
<p>Navigate to the following key: <strong>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines\ACE</strong></p>
<p>In the right pane find the &#8216;MaxLocksPerFile&#8217; entry and modify it&#8217;s <strong>DECIMAL</strong> value to 100000 or 200000 or Hexadecimal value to <strong>30d40</strong>. Default decimal value is <strong>95000</strong>. Close the registry editor and restart Microsoft Access to apply the settings.</p>
<p><strong>Note:</strong> If you have changed the Indexed property of a field and duplicate data already exists in the table, you can either reset the Indexed property back to the previous setting, or remove the duplicate records from the table.</p>