Opening MSAccess MDB in Offiice 2016

I have an old MDB file that I need to access but get an error "The Microsoft Access database engine could not find the object 'Databases'. Make sure the object exists..." when I try to open it in Office 2016. I think the last time the file was saved it was in Office 2010.
Warren GibsonRetiredAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

OddyWriterMr.Commented:
0
Mahima GuptaSoftware AnalystCommented:
Hi,

It sounds like begging of corruption get starts (not sure), check whether your .mdb files are in the actual state or not, if not then try to recover your corrupt MDB file first, but make sure to take backups before and after using the tool or any other alternatives.  
found few threads on this but not exactly the solution, maybe you can
https://community.spiceworks.com/topic/1475332-can-t-open-mdb-file-after-office-365-2016-upgrade
https://social.msdn.microsoft.com/Forums/office/en-US/4b4dceed-a45b-4d6d-b53b-4e584244f65b/the-microsoft-access-database-engine-could-not-find-the-object-make-sure-the-object-exists-and?forum=accessdev
https://support.microsoft.com/en-in/help/2755119/-cannot-open-a-database-created-with-a-previous-version-of-your-applic

Thank you
0
Jeffrey CoachmanMIS LiasonCommented:
This is always a tricky issue with MS Access databases, ...it is not really a matter of what version of Access the file was previously opened with.
last time the file was saved it was in Office 2010
...it may be more of what version of the "file format" it was saved under.

The .MDB file format has undergone a few changes in its lifetime.
So has the ACCDB format...
This means that you may have issues if you create an MDB file in Access 2013 and try to open it in Access 2000. (even though they are both .mdb files)
This is is also true of .accdb files created in Access 2013 and being opened in Access 2007.

The first thing you should do before subjecting your file to any utility is to make a backup of the original file. And make copies of this file to do your testing.
Take one of the copies and see if it can still be opened on an old PC with Office 2010 (or any other Office version between 2010 and 2016)
If so,...then confirm that all the data and functionality still exist.
Then run the compact/repair utility, ...then check the file data and functionality again.
If all is well, ...I would save the file as an .ACCDB file.
Then try opening this new .accdb file with access 2016.

Hope this helps some as well

;-)

JeffCoachman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Warren GibsonRetiredAuthor Commented:
Thanks for all the help!!!
0
Jeffrey CoachmanMIS LiasonCommented:
;-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.