Solved The Database you are trying to open requires a newer version of Microsoft Access. (1 Viewer)

[ZKHADI]

My pc Microsoft office auto updated to 365 and now after uninstall i am facing this error. how can i reverse back to old version to open this file.

 

[gemma-the-husky]

What version of access were you using before?

Sorry, I've changed my answer. It sounds somehow like your database includes features that aren't supported in the version you are using.
Is this an accdb/mdb or an accde/mde?

Do you have two versions of access installed?

 

[ZKHADI]

i was using 2016 office but i uninstall the version from control panel and i saw the icon changed to 365. i dont want 365 anymore. so how to revert back to normall 2016

 

[arnelgp]

there are Newer system tables on the new MSA, that maybe the reason that you are seeing the error on A2016.
you need to re-install 365/2021 for the mean time and export all your database objects.
re-install A2016 and re-import the objects to the new database.
see this thread:
Restore Database Objects (LoadFromText) | Access World Forums (access-programmers.co.uk)

 

[ZKHADI]

thank you arnelgp. this way is very long. as i update office to 365 the file open. but i dont want 365. give me any shortcut way to open file without 365 office

 

[Gasman]

thank you arnelgp. this way is very long. as i update office to 365 the file open. but i dont want 365. give me any shortcut way to open file without 365 office

It might well be , but that should fix it.

 

[ZKHADI]

It might well be , but that should fix it.

i tried stelar phonex access repair but failed

 

[Gasman]

i tried stelar phonex access repair but failed

if @arnelgp is correct, then there is nothing to repair?
Just do it, what do you have to lose, you cannot use it at the moment anyway?

 

[ZKHADI]

if @arnelgp is correct, then there is nothing to repair?
Just do it, what do you have to lose, you cannot use it at the moment anyway?

ok i will test arnelgp codes

 

[isladogs]

Sorry to disagree but the system tables haven't changed since A2010.

The most likely cause of this error message is that you ticked one or both of the datatype support options below

If you untick those options in the newer version, the database structure changes are reversed.
In other words, you will be able to use the database in older versions (despite warning messages to the contrary)

 

[ZKHADI]

Sorry to disagree but the system tables haven't changed since A2010.

The most likely cause of this error message is that you ticked one or both of the datatype support options below

View attachment 110990

If you untick those options in the newer version, the database structure changes are reversed.
In other words, you will be able to use the database in older versions (despite warning messages to the contrary)

thanking you for your suggestion i wil try and let you know

 

[ZKHADI]

already unchecked but not working

 

[arnelgp]

already unchecked but not working

you ask the MVP?!

 

[ZKHADI]

no didnt ask.

 

[ZKHADI]

i did it. sharing experience with other friends who facing problem.

i installed 2016 and update with 365 and install 2013 not updated.

then i make file and opened with 2013 and open old file with 2016 365 version.
then i copy macros, tables, queries as drag and drop in new 2013 accdb file.
then i export forms one by one to new 2013 accdb file after close file. because cant export to opened file.
and this method work for downgrading file. now i can open this file with 2016 or 2013 not updated to 365 .
thank you for all who give their suggestions.

 

[isladogs]

@ZKHADI
Your screenshot in post #12 only shows one data type support option checkbox. Was that from the older version e.g. 2016 which didn't support the DateTime Extended feature?
As previously mentioned, you would have needed to disable that option in 365, remove any DTE fields or change to standard DateTime, and then save. After doing that, the file should have opened in older versions without error.

Anyway, you now have a solution even if it took a few extra steps.