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

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
LVL 1
KevinAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
<<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
 
KevinAuthor Commented:
Thank you for your response Jim.

Can you tell me why it is best to avoid 64-bit office, in relation to Access?
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<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
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
Helen FeddemaCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
KevinAuthor Commented:
Thanks much for all the explainations.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.