How to overcome the error message in Ms Access Runtime 2016

Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc used Ask the Experts™
on
Hi Experts!

I have an error message while trying to open an Ms access 2016 on one of the machines see the error message below , I do not have a full version but just runtime 2016 on the target machine , but other machines all is okay:

the database you are trying to open requires a newer version of Microsoft access



Office-Error.pngOffice-Error.png
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
John TsioumprisSoftware & Systems Engineer

Commented:
In this machine you have 64bit Access and your application is 32bit
Either install the 32bit Access or open the application in design (you need to  have full Access installed) and resolve the issues that they will pop up
We have all 32 BIT office I have double checked,
John TsioumprisSoftware & Systems Engineer

Commented:
Strange this error appears on 64bit Access when trying to run 32bit Access .
Maybe they had 64bit Office/RT....uninstalled and reg entries remained and causing this
If you have 64bit Access create a small dummy application to verify.
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

This has nothing to do with 32/64 bit.

Make sure that the runtime you are using is updated. Verify that they are indeed both 2016.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
To extend Ander's comment a bit, it's probably related to BigInit support:

https://www.microsoft.com/en-us/microsoft-365/blog/2017/03/06/new-in-access-2016-large-number-bigint-support/

  Once you turn it on for a DB, you must be on a specific build or greater to use the database.   You even get a warning when you add the support to that effect.

Jim.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
FYI little more detail in this article here:

https://support.office.com/en-us/article/using-the-large-number-data-type-5b623f6e-641d-4e97-8bdf-b77bae076f70

Look at the section "Stamping of Access 2007-2016 file format (.accdb) to Access 2016"

Jim.
Okay !

Now I see the actual problem here, it comes in if I use LARGE NUMBER as data type then this problem is ignited , but If I change the controls that have data type LARGE NUMBER  to NUMBER then the problem goes.

Is there a way to sort out this because surely these controls require LARGE NUMBER  to gain on performance ????????

Jim has spotted this problem correctly , is there any run-time which is equivalent to Access 2016 (16.0.7812 or later)?????



Regards

Chris
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
The runtime here:

https://www.microsoft.com/en-us/download/details.aspx?id=50040

which is the latest that I'm aware of that is a MSI install.   If these machines don't have office installed at all, you can use the Office 365 CTR install:

https://support.office.com/en-us/article/Download-and-install-Office-365-Access-Runtime-185c5a32-8ba9-491e-ac76-91cbe3ea09c9

 But note that you'll be getting the latest version of Access that way (basically Access 2019), which might not work with your app correctly (it should however).

 If you want to avoid the issue and you are not using large number, then I would convert the database back using the instructions in the article (very last item - "Remove Large Number data type support from a database in Access 2016 file format")

Jim.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial