title: Can't change data type on MS Access 2007
body: <p>I have a huge database (800MB) which consists of a field called 'Date Last Modified' at the moment this field is entered as a text data type but need to change it to a Date/Time field to carry out some queries.</p>
  
  <p>I have another exact same database but with only 35MB of data inside it and when I change the data type it works fine, but when I try to change data type on big database it gives me an error:</p>
  
  <pre><code>Micorosoft Office Access can't change the data type.
  
  There isn't enough disk space or memory
  </code></pre>
  
  <p>After doing some research some sites mentioned of changing the registry file (MaxLocksPerFile) tried that as well, but no luck :-(</p>
  
  <p>Can anyone help please?</p>