Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2014-09-21
3
Medium Priority
?
2,267 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 49

Accepted Solution

by:
Dale Fye earned 2000 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 85
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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

578 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