HEELPBOOK - Can't change the data type (Microsoft Access 2007) ##########################

When you perform an operation on an Access 2007 table, you might experience the following error:


Microsoft Office Access can't change the data type. There isn't enough disk space or memory.
Errors were encountered during the save operation.
Data types were not changed. Properties were not updated.


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.

However, this it is not a recommended solution from Microsoft and you are editing registry at your own risk.

Open the registry by typing 'Regedit' in the Run Window. Win+R | Regedit | Enter

Navigate to the following key:


HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Access Connectivity Engine\Engines\ACE


In the right pane find the 'MaxLocksPerFile' entry and modify it's DECIMAL value to 100000 or 200000 or Hexadecimal value to 30d40. Default decimal value is 95000. Close the registry editor and restart Microsoft Access to apply the settings.

Note: 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.


############ ARTICLE INFO #############

Article Month: November
Article Date: 30/11/2012
Permalink: http://heelpbook.altervista.org/2012/cant-change-the-data-type-microsoft-access-2007/comment-page-1/
Source: http://www.wincert.net/tips/microsoft-office/1964-microsoft-office-access-cant-change-the-data-type
Language: English

View more articles on: http://www.heelpbook.net/
Follow us on Facebook: http://it-it.facebook.com/pages/HeelpBook/100790870008832
Follow us on Twitter: https://twitter.com/#!/HeelpBook
Follow us on RSS Feed: http://feeds.feedburner.com/Heelpbook
Follow us on Delicious: http://delicious.com/heelpbook
Linkedin: http://it.linkedin.com/pub/stefano-maggi/27/73a/b20
Google+ : https://plus.google.com/116990277568167008289/posts