CODEWITHSUNDEEP
excelms-accessodbcoledb
Anthony
Anthony

Reputation: 116

MS Access database require newer version

relating to MS Access, currently i'm suffering with this error every time i open the access accdb file. It says "The database you are trying to open requires a newer version of MS Access".

I am fully understand that based on that i have to update it. But the question is, everything just fine before or never happened before whenever i use this file. So it doesnt make any sense if i have to update.

My assumption so far:

it happened because some error in ODBC connection between access and excel that impact the database. because i use this access to be a database for my excel pivot.

Anyone has same experience? Your help means a lot for me, because if i can't open this then i have to re-coding from scratch :( (the back up also has the same issue, but other access file can be opened smoothly)

Thank you,

Upvotes: 0

Views: 2940

Answers (2)

Malik Abuzar
Malik Abuzar

Reputation: 1

This worked for me when I was making C# application and it was connected to MS Access DB. Go to MS Access DB -> File -> Info -> Compact and Repair. This will downgrade the version and fix this issue.

Upvotes: 0

Anthony
Anthony

Reputation: 116

The solution is just simply install access 2010.

Yes, it is funny that I am reinstalling the older one but it works..

Upvotes: 1

Related Questions