Solved

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

Posted on 2013-10-29
6
2,286 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
6 Comments
 
LVL 57

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 57
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

726 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