Help with this error "The database you are trying to open requires a newer version of Microsoft Access"

[Abeetan]

Hello,

I am getting the following error on my colleague's PC, whereas, on my PC, the database doesn't open once I double click on it. It just shows the temporary file underneath the main Access file and doesn't open up. I have to Task Manager and "End Task" for MS Access.

"The database you are trying to open requires a newer version of Microsoft Access"

I am using the subscription-based access version (Up-to-date), I believe my other colleague is using the 2019 Access version.

Note: I don't get the above error message, only my colleague does, however, this is what I am experiencing with the current database on my PC, it freezes and doesn't open. I have another database that is very similar to the one above, no issues whatsoever.

 

[arnelgp]

does your colleage has old version of Ms access?
if you developed it on New version, some system tables
of new version will not be recognized on old version.

 

[Abeetan]

does your colleage has old version of Ms access?
if you developed it on New version, some system tables
of new version will not be recognized on old version.

He is using the 2019 version.

 

[arnelgp]

maybe you have corrupt[pt db.

 

[arnelgp]

there is a recommendation here:
Database requires a newer version of Access - Office | Microsoft Docs

 

[Abeetan]

there is a recommendation here:
Database requires a newer version of Access - Office | Microsoft Docs

When I try to open the Access file on my end, the files doesn't open but the temporary file is created just underneath as shown in the image I attached. What could be causing that?

 

[arnelgp]

can you post it here for analysis or if you can upload it to dropbox or google drive or one drive and paste the link here.

 

[Abeetan]

I can't upload it. It contains sensitive private data for my company. However, it seems that it happens especially when I hold down the shift key to by pass security.

 

[moke123]

I can't upload it. It contains sensitive private data for my company. However, it seems that it happens especially when I hold down the shift key to by pass security.

Make a copy of your database and delete sensitive data or you can randomize the sensitive data. See the utility posted here . . . https://www.access-programmers.co.u...zing-data-for-posted-dbs.306745/#post-1640309

 

[arnelgp]

Make a copy of your database and delete sensitive data or you can randomize the sensitive data.

see post#1, Note portion.

 

[moke123]

can you post it here for analysis or if you can upload it to dropbox or google drive or one drive and paste the link here.

I was responding to posts #7 and #8

 

[arnelgp]

I was responding to posts #7 and #8

i know, but he can't randomized the data since he cannot open it (see Note post#1).

 

[moke123]

which leads to the question "Is the database split?"

 

[Abeetan]

which leads to the question "Is the database split?"

Yes, the database is split.

 

[Abeetan]

Update: The database works perfectly on my end. When I open it once, it works, then when I try to open it after I closed it, I get this.

The database won't open (This is the back end of the database) I have to go to task manager and end task for MS Access then I can open the database again. This keeps happening.

 

[ZKHADI]

i also faced that problem. same version of Office 2016 i made file and after new window it doesnt work. so i repaired file with stellarphonex access repair software. then everything worked well.