“无法打开使用以前版本创建的数据库...” /// Application.CompactRepair ///从旧的.mdb中提取数据 [英] "Cannot open a database created with a previous version..." /// Application.CompactRepair /// Extract data from an old .mdb

问题描述

尝试打开由15岁以上的软件创建的.mdb文件，并且不出所料，访问是抗议：

"无法打开使用以前版本的应用程序创建的数据库。" //确定//帮助//

文件仍然在原始x86软件中运行，并且已由旧版本的访问过去。   

通过Office 365 ProPlus运行Win10 Pro（10.0.15063）x64和Access 2013（15.0.4963.1000）x64，所有更新都已应用。

由于我无法打开文件，因此无法通过重新保存来解析
convert ，并且无法执行任何VBA技巧，例如
标识文件源自哪个版本的 - 所以我不能排除它是Access 97说服的.mdb 。

希望找到一个不需要我构建虚拟机的解决方案只是为了安装一个简单到足以成为.csv 的数据库的Access 2010。 strong>

我尝试了什么：

点击'帮助'关于弹出错误打开这个可爱的
错误3041帮助页面，这表明我"压缩数据库"，并提供两个链接（下面）到Office VBA中的条目参考如何这样做。 这两个页面都没有任何内容。  （即使这些确实包含了承诺的信息，
如果文件不会打开，VBA如何帮助？） 

关于错误的TechNet库条目证明了（非）有用。

使用Excel并导入数据" ;来自Access"如果没有工作，MS Office 12和15 DB OLE Providers都会抛出与Access相同的错误。 旧的Jet x32驱动程序没有选项，可能是因为它是x64安装的Office。

还有其他想法吗？

编辑：显然我五岁的帐户不是没有正确验证（??）并删除了链接......

https://support.office.com/en-us/article/Convert-a-database-to- -accdb-file-format-098ddd31-5f84-4e89-8f44-db0cf7c11acd

https://blogs.technet.microsoft.com/heyscriptingguy/2005/10/07/how-我可以确定哪个版本的访问被用来创建一个数据库/

https://msdn.microsoft.com/en-us / VBA / access-vba / articles /无法打开数据库创建的以前版本的应用程序错误

https://msdn.microsoft .com / library / 4820fd79-d907-21bc-0ad5-5fc096c1ef3b％28office.15％29.aspx

https://technet.microsoft.com/en-us/library/bb221761 （v = office.12）.aspx

解决方案

只是在黑暗中拍摄，因为你可能已经尝试过，但看看

这篇文章。

希望它有所帮助......

Trying to open .mdb files created by 15+ year old software and Access is, unsurprisingly, protesting:

"Cannot open a database created with a previous version of your application." // OK // Help //

Files still function in originating x86 software, and have been opened by older versions of Access in the past.   
Running Win10 Pro (10.0.15063) x64 and Access 2013 (15.0.4963.1000) x64 via Office 365 ProPlus, all updates applied.

Since I can't open the file, I'm unable to convert it by re-saving it, and can't perform any VBA tricks, such as identify what version of Access the file originated from - so I can't rule out it being an .mdb of the Access 97 persuasion.

Hoping for a solution that doesn't require me building a VM just to keep an install of Access 2010 around for a DB that's simple enough to be a .csv

What I've tried:

Clicking 'Help' on the popup error opens this lovely error 3041 help page which suggests I "compact the database", and provides two links (below) to entries in the Office VBA Reference on how to do so.  Neither page has any content.  (Even if these did contain the promised info, how could VBA help if the file wont open?) 

TechNet Library entry on the error proved just as (un)helpful.

Using Excel and importing data "From Access" hasn't worked, both MS Office 12 and 15 DB OLE Providers throw the same error as Access did.  No option for the older Jet x32 driver, probably because it's an x64 install of Office.

Any other ideas?

EDIT: Apparently my five-year-old account isn't verified properly (??) and links were removed...

https://support.office.com/en-us/article/Convert-a-database-to-the-accdb-file-format-098ddd31-5f84-4e89-8f44-db0cf7c11acd

https://blogs.technet.microsoft.com/heyscriptingguy/2005/10/07/how-can-i-determine-which-version-of-access-was-used-to-create-a-database/

https://msdn.microsoft.com/en-us/VBA/access-vba/articles/cannot-open-a-database-created-with-a-previous-version-of-your-applicationerror

https://msdn.microsoft.com/library/4820fd79-d907-21bc-0ad5-5fc096c1ef3b%28office.15%29.aspx

https://technet.microsoft.com/en-us/library/bb221761(v=office.12).aspx

解决方案

Hi,

Just a shot in the dark because you probably tried it already, but take a look at this article.

Hope it helps...

这篇关于“无法打开使用以前版本创建的数据库...” /// Application.CompactRepair ///从旧的.mdb中提取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！