Link to home
Create AccountLog in
Avatar of Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScFlag for Zambia

asked on

How to overcome the error message in Ms Access Runtime 2016

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



User generated imageOffice-Error.png
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

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
Avatar of Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc

ASKER

We have all 32 BIT office I have double checked,
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.
ASKER CERTIFIED SOLUTION
Avatar of Anders Ebro (Microsoft MVP)
Anders Ebro (Microsoft MVP)
Flag of Denmark image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
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.
SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
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
SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.