Opening MSAccess MDB in Offiice 2016

Warren Gibson
Warren Gibson used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mahima GuptaSoftware Analyst
Commented:
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
MIS Liason
Most Valuable Expert 2012
Commented:
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
Warren GibsonRetired

Author

Commented:
Thanks for all the help!!!
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
;-)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial