Solved

"The Microsoft Office Access database engine cannot read the data....." error in Excel 2013

Posted on 2014-09-21
3
1,584 Views
Last Modified: 2014-09-22
"The Microsoft Office Access database engine cannot read the data in tblABCD. The minimum required version to read the data is 14.0.0000.0000".

I've seen other people having this issue when attempting to open a >2010 file in 2007. This problem is arising when opening a 2013 file in 2013 on another PC... ie like with like.  I've tried this on several PCs and only had the issue on one particular PC.

Created using version: 15.0.4649.1001
Error on opening using version: 15.0.4649.1003


Anyone have any thoughts?
0
Comment
Question by:JDido
3 Comments
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 500 total points
ID: 40336098
1.  Does the affected PC have more than one version of Access installed?  If that is the case, open the version of Access (2013) first, then try to open the file from there rather than simply double-clicking on the file name.

2.  Does this only happen with this one file?
0
 
LVL 84
ID: 40336228
I've tried this on several PCs and only had the issue on one particular PC.
That would mean it's environmental - i.e. that "one particular PC" has a problem.

Generally that would be troubles with the installation of Access/Office and/or Windows. Make sure all of those are fully up to date. In some cases, a repair or reinstall of Office/Access would be in order.

Could also be troubles with the user profile on that machine. Try logging into the machine with a different username and password. If the troubles go away, then the user profile is at fault and you'd have to recreate it.
0
 

Author Closing Comment

by:JDido
ID: 40338254
Turned out to be a 2007 Runtime version lurking in the background.
Uninstalled and problem fixed.

Opening the accdb file from explorer was launching 2007.
File opened fine from File>Open in 2013.

Simple solution!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now