Skip to main content

Datasheet view not working in 64 bit Office 2010

By default, the Datasheet view of a list or library is not supported when you are using the 64-bit version of Microsoft Office 2010 installed on a 64-bit Windows operating system.

If you want to use Datasheet view, It is recommended to install the 32-bit version of Microsoft Office on a 64-bit Windows operating system.

If your business needs require using the 64-bit version of Office 2010, you can install the 2007 Office System Driver: Data Connectivity Components to enable the Datasheet component.

Comments

Popular posts from this blog

SQL Azure Error - 40544

If the size of your database reaches its MAXSIZE you will receive an error code 40544. You cannot insert or update data, or create new objects (such as tables, stored procedures, views, and functions).To fix this issue either increase your database size or delete data. For increasing/decreasing SQL Azure database size, you can use this command on the Master database. Alter DATABASE database_name MODIFY (MAXSIZE = {1|5|10|20|30… 150}GB); example: ALTER DATABASE sampleDB MODIFY (MAXSIZE = 5gb);

Hardware DEP (Data Execution Prevention), NX, XD & EVP

A processor can be instructed to designate regions of memory as non-executable. This means that the memory can be used to store reference data to be read and written, but that the processor cannot treat the contents of the memory as program code to be directly executed. Intel calls this capability in their newer processors XD for “eXecute Disable” and AMD refers to it as NX for “No eXecute.” AMD's marketing materials also sometimes refer to this capability by the term EVP for Enhanced Virus Protection.
As a hardware capability of modern processors this addition is important, but its use depends entirely upon support from the operating system. So when Microsoft introduced support for this into their operating systems, they termed it Hardware DEP for Data Execution Prevention. Support for hardware DEP was introduced into the 32-bit versions of Windows XP with Service Pack 2, into Windows 2003 Server with Service Pack 1, and has always been present in Windows Vista. Hardware DEP does …