Solved

Access 32-bit file in Access 64 bit, is this possible?

Posted on 2013-10-29
6
2,519 Views
Last Modified: 2013-10-29
Afternoon,

I am in the process of making something for my users in Access 2010 32-bit (Home Computer).

I figured I would work on it today on Access 2010 64-Bit (Office computer) and upon opening the .accde file I get a message saying it was built in a 32-bit version of Access and cannot be opened on my office computer.

I was able to finally open the file as a .accdb, but I am wondering if everything will still work as it should.

Is someone able to confirm this or advise how I can convert it to 64-bit without starting from scratch.

Regards,
N
0
Comment
Question by:nobushi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 total points
ID: 39609545
<<I was able to finally open the file as a .accdb, but I am wondering if everything will still work as it should.>>

 The answer is, "it depends".

 If you have not used any 3rd party controls, DLL's, or made any API call's, then it will work fine.   It could even be moved back to a 32 bit machine.

 If you do have things like that, then you'll need to make some modifications.   If API or DLL calls, then you can write the DB in such a way that they will work in 32 bit and 64 bit environments.

 With 3rd party controls however, you've got a problem.   In that case, you'd need to maintain two versions.

 It's actually best to avoid 64 bit Office at present, unless you need extremely large spreadsheets in Excel.  Even Microsoft still recommends the 32 bit version.

Jim.
0
 
LVL 1

Author Comment

by:nobushi
ID: 39609589
Thank you for your response Jim.

Can you tell me why it is best to avoid 64-bit office, in relation to Access?
0
 
LVL 58
ID: 39609606
<<Can you tell me why it is best to avoid 64-bit office, in relation to Access?>>

 It's not just in relation to Access, but all of Office.

 Basically it's the lack of 3rd party controls and software to work in conjunction with 64 bit Office.

 Right now, the only difference between the two is that the 64 bit addressing allows you to have extremely large spreadsheets in Excel.  Outside of that, 64 bit offers nothing else.

For 2010:
Choose the 32-bit or 64-bit version of Office
http://office.microsoft.com/en-us/word-help/choose-the-32-bit-or-64-bit-version-of-office-HA010369476.aspx

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

Jim.
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 31

Expert Comment

by:Helen Feddema
ID: 39609616
When I installed Office 2013 on a computer running 64-bit Windows, one of the installation dialogs (from Microsoft) advised installing the 32-bit version of Office.  Looks like they still haven't figured out this problem.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 39609650
I'll help a bit. (No Points wanted)

When you "go up" to 64 bit development,  you cannot easily "go down" to 32 bit for users.
In other words: A 10 pound sack of flour(64 bit) cannot fit in a 1 pound bag(32 bit).
;-)

A lot of controls are specifically written for 64 bit applications and cannot run on 32 but apps.
So another analogy is that you cannot reliably run Access (32 bit) on a old 16 or 8 bit computer.

64 bit Access offers some benefits over 32 bit (Possible use of more memory, as a simple example), ...but the loss of compatibility often negates the advantage in most cases.

Like so many things in the world of computers, ...you should not upgrade until *everyone* will be upgraded to the same version, at pretty much the same time.


;-)
0
 
LVL 1

Author Closing Comment

by:nobushi
ID: 39609712
Thanks much for all the explainations.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

689 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