Microsoft Access 2019: open 32-bit database with 64-bit Access

how do you open an access file created with 32 bit when your own program is 64 bit
|

That depends.

There is no such thing as an "Access file"; you have to be more specific.

If this is an accde file: it has to be compiled by the developer for 64-bit. If not, it won't work.

If this is an accdb file, you may want to first decompile it. Search online for "Access decompile".

-Tom.
Microsoft Access MVP
Phoenix, AZ

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

What is the file extension of the file you are trying to open?

If the database was originally created on 32-bit and now you wish to use it on 64-bit, then APIs needs to be updated, ActiveX, ... Refer to

https://www.devhut.net/2017/04/13/access-x32-vs-x64-compatibility/

The easier option is to uninstall office and reinstall the 32-bit version as 64-bit offers little to no advantages for the average user and instead causes all sorts of headaches.

--
Daniel Pineault
Microsoft MVP 2010-2020

3 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

How do I download the 32 bit version?  The download automatically did the 64 bit version and the application I'm trying to use needs the 32 bit.

3 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

What I have is a program called Obedience Solution that is an MDE database.

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

"sign in to ... www.office.com and select Other install options, choose the language and version you want (64 or 32-bit), and then select Install."

https://support.microsoft.com/en-us/office/download-and-install-or-reinstall-microsoft-365-or-office-2019-on-a-pc-or-mac-4414eaaf-0478-48be-9c42-23adc4716658#installsteps=pc_step-by-step

--
Daniel Pineault
Microsoft MVP 2010-2020

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Do I have to uninstall the Office Home also?  Since the Access 2019 was a stand alone I sure hope not!

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

You cannot mix the burners of a single version of Office applications.  You can only mix them if they are of different versions.

What do I mean.

If everything is Office 2016, then you need to completely uninstall everything and reinstall everything in 32-bit.

If on the other hand, you have Office 2016 with Access 2013, then you should be able to leave Office 2016 as is and uninstall and reinstall only Access as 32-bit.

That said, for 99% of users 64-bit gives absolutely nothing and simply causes problems with APIs, ActiveX, ... So most of the time, I recommend switching everything back to 32-bit.

--
Daniel Pineault
Microsoft MVP 2010-2020

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

My understanding of your comments is that I could delete the Microsoft Office Home & Business 2019, leaving the MS Office Home & Student2016, then install the Access 2019 and it should function.   

This computer was purchased for a specific use by me as a trial secretary for AKC obedience and rally trials for a local kennel club by someone other than me.  The person has refused to provide keys, passwords and claims she doesn't know how to do the tasks for which I have written complete instructions.  

Is there a way to find out the keys to the software in order to reinstall one of the programs at a later date?

I so appreciate your help with this mess!

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

The keys for the latest versions are now stored online as part of the person's Microsoft account.

You simply log into the account and from there you should be able to reinstall it.  So get them to login and validate before proceeding.

--
Daniel Pineault
Microsoft MVP 2010-2020

3 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Thank you for the help.  The Access database is now functioning as it should!  

3 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated June 3, 2021 Views 10,595 Applies to: