Solved

Is anyone using Microsoft Access 64 bit successfully

Posted on 2013-10-31
6
253 Views
Last Modified: 2013-11-09
This seems like an odd question, and I don't mean to be impertinent, but I seriously wonder - Is anyone using Microsoft Access (particularly 2013) successfully in 64 bit mode? I am an Access Developer so this is not a naive question.

If so, I'd like to know how and under what circumstances.  In the past the general advice (from all respected sources it seems) was to avoid 64 bit Access and use 32 bit instead.  I think a good portion of this had to do with problems when making API calls, but there may be other things too.  If so, I wonder how significant the problems are.  If they are not particularly significant, I am inclined to switch to Access 64 bit.  I seldom make API calls though I can think of a couple of instances where I need to get a computer name or name of a user.  I suppose, however, there are work-rounds.

Again,  is anyone using 64 bit Access successfully and happy with it?
0
Comment
Question by:WoodrowA
6 Comments
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 250 total points
ID: 39614355
I've found that many of the API calls have been tweaked to work with 64 bit Access, so other than putting some conditional compilation into those applications, that has not been a major problem for me.

There are also issues with ActiveX controls in the 64 bit Access.  I have one client that has both 32 and 64 bit systems, and they purchased 64 bit Offices because of one of the business intelligence systems recommended it.  My treeview controls don't work in that application.

My advice, unless you actually need the increased numeric processing (working with really large numbers) of Excel, stick with 32 bit Office.
0
 

Assisted Solution

by:WoodrowA
WoodrowA earned 0 total points
ID: 39614397
@Fyed

Thank you for responding.

The only ActiveX code I use (that I remember) has to do with ADO. Does ADO fall under the "potential problems" category?  I do not write large applications involving numerous machines in a variety of environments.  As of now, what I write for others is controlled.  That is I have some say on the kind of machines being used and the software involved.

It is hard for owners of smaller companies to understand why they can't make use of the latest and greatest from Microsoft.  64 bit machines are all you can buy these days and the leader in the PC software industry is still Microsoft, and yet, hardly anyone is actually using 64 bit Access.  It will surprise me if I get many, if any, additional responses to my question.  

I suppose that alone should tell me something, but unless there is a good reason not to, given the kind of applications I write, I am inclined to at least consider a 64 bit solution.  Everyone naturally wants to install the latest version of Office in 64 bit mode.
0
 
LVL 47

Assisted Solution

by:Dale Fye (Access MVP)
Dale Fye (Access MVP) earned 250 total points
ID: 39614562
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 125 total points
ID: 39614595
Besides what Dale posted, here's another Microsoft Technet article:

64-bit editions of Office 2013
http://technet.microsoft.com/en-us/library/ee681792.aspx

 The issue with Office 64 bit edition is the lack of 3rd party controls, drivers, etc.

  API calls can be changed, and even written in such a way that the same Access DB can be used with either.

 But on the flip side, the 64 bit edition offers nothing feature wise other then having the ability to address a larger address space.  So you can have larger Excel spreadsheets and Project files and that's it.

  And as you will see from the articles, even Microsoft itself still recommends 32 bit version for most users because of those reasons.

Jim.
0
 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 125 total points
ID: 39615051
WoodrowA,

he only ActiveX code I use (that I remember) has to do with ADO.
ADO is not an issue.

Issues with ActiveX control is referring to controls that are not part of the standard/built-in controls installed with Access.  You will have to get the 64-bit version of the control. The problem is that there is a high chance that  there is not one available.

For all my apps that do can run in both 32/64 bit I will use conditional compiling to compile a MDE/ACCDE in both 32 and 64 bit. So far I have no need.

FWIW: I have yet to have a client install the 64-bit Office 2010 or 2013. Because of this I can't deploy a 64-bit Access MDE/ACCDE without using a VM.  

In my testing with Access 2010 64-bit I have yet to see any advantage to using the 64 bit version. Since you can't have Office 64 bit app and the Access 32 bit version installed the same Windows instance, that is the only reason I can find to use the Access 64-bit version. Just so it can co-exist with the other 64-bit Office apps.

If you decide to do all your Access apps in the 64-bit version then you will also be required to install the 64-bit version of all the other  Office apps in the same Windows Instance.

Note: I keep referring to the same Windows Instance because you can use a VM to install both the 32-bit and 64-bit versions of Office app on the same hardware in separate Windows Instances.
0
 

Author Closing Comment

by:WoodrowA
ID: 39635449
Thank you all
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will show you how to use shortcut menus in the Access run-time environment.
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now