Change 64 bit Access to 32 bit (1 Viewer)

DataBass

Registered User.
Local time
Today, 02:19
Joined
Jun 6, 2018
Messages
68
I have built a database for a client which they have been using for quite some time. Recently they had some sort of issue which prompted them to uninstall and reinstall Office 365 on their machines. Unfortunately, they installed the 64 bit version and the database was built using the 32 bit version and they are now getting the error telling them that they can't open the database.

In the past, this would not have been much of an issue, but now Microsoft, in its infinite wisdom, has removed the ability to uninstall an individual Office program, you have to uninstall ALL of Office. I could be wrong on this, but this appears to be the case.

I am trying to figure out the best course of action here. I am very reluctant to have them completely uninstall Office again and have to reconfigure everything. That would be a nightmare.

It appears my options are as follows:
1. Uninstall/reinstall Office (worst case)
2. Convert the database on my end to 64 bit. I honestly don't know if this is even possible
3. Recreate the database and package it with Access runtime
4. Host the database remotely and have them access it in a virtual environment of some sort
5.???

Have any of you encountered a similar problem/situation?

Any ideas/suggestions/recommendations?

I'm all ears.
 

theDBguy

I’m here to help
Staff member
Local time
Today, 02:19
Joined
Oct 29, 2018
Messages
21,357
2. Convert the database on my end to 64 bit. I honestly don't know if this is even possible
This is very possible and what most developers do. (I think) You should probably try to do the same.
 

isladogs

MVP / VIP
Local time
Today, 09:19
Joined
Jan 14, 2017
Messages
18,186
I agree.
If you use API declarations, these will need converting but its something that many of us do.
The only problem you may have is that some ActiveX controls don't work in 64-bit e.g flexgrid
 

DataBass

Registered User.
Local time
Today, 02:19
Joined
Jun 6, 2018
Messages
68
Thanks for the input. I am checking to see if converting will be viable.



I'm not going to ask any of you to hold my hand and tell me how you do this, but I have some questions:


1. Do you have both 32 bit and 64 bit Office installed on your PC or do you have separate machines for doing this?



2. If both are installed on the same machine, are they the same version of Office or different versions?
 

isladogs

MVP / VIP
Local time
Today, 09:19
Joined
Jan 14, 2017
Messages
18,186
You cannot install both 32-bit and 64-bit Office on the same workstation unless one of them is installed on a virtual machine.
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 04:19
Joined
Feb 28, 2001
Messages
26,996
The only time I ever saw a 32/64 dual install, the app specialist fought it for close to a month before giving up because they never quite got it right. Not disagreeing with Colin, just telling you what happened when we tried it. It wasn't a pretty sight, either.
 

Users who are viewing this thread

Top Bottom