[AccessD] 32 bit mde incompatible with 64 bit office

Stuart McLachlan stuart at lexacorp.com.pg
Sun Jan 13 02:33:08 CST 2013


More to the point, there are a number of disadvantages to 64bit Office:

http://msdn.microsoft.com/en-us/library/office/ee691831%28v=office.14%29.aspx

There are two fundamental issues when you run existing solutions with the 64-bit version of 
Office 2010:

    Native 64-bit processes in Office 2010 cannot load 32-bit binaries. This is expected to be a 
common issue when you have existing Microsoft ActiveX controls and existing add-ins,

    VBA previously did not have a pointer data type and because of this, developers used 
32-bit variables to store pointers and handles. These variables now truncate 64-bit values 
returned by API calls when using Declare statements.

...

Existing 32-bit ActiveX controls, both third-party and Microsoft-supplied, are not compatible 
with the 64-bit version of Office 2010. For ActiveX controls and COM objects, there are three 
possible solutions:

    If you have the source code, you can generate a 64-bit version yourself,

    You can contact the vendor for an updated version,

    You can search for an alternative solution.

Native 64-bit processes in Office 2010 cannot load 32-bit binaries. This includes the common 
controls of MSComCtl (TabStrip, Toolbar, StatusBar, ProgressBar, TreeView, ListViews, 
ImageList, Slider, ImageComboBox) and the controls of MSComCt2 (Animation, UpDown, 
MonthView, DateTimePicker, FlatScrollBar).These controls were installed by previous 
versions of Microsoft Office and are installed by 32-bit Office 2010. An alternative must be 
found for existing Microsoft Office VBA solutions that utilize these controls when the code is 
migrated to 64-bit Office 2010. 64-bit Office 2010 does not provide 64-bit versions of the 
Common Controls.




On 13 Jan 2013 at 2:04, Arthur Fuller wrote:

> There is only one, and that is the huge spreadsheets available in Excel-64.
> Aside from that, there are zero advantages.
> 
> A.
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 




More information about the AccessD mailing list