其中包含的VBA项目无法读取 [英] VBA project contained in it cannot be read

问题描述

我正在尝试在Access 2007中恢复数据库。我没有可行的备份。错误消息是：


无法打开数据库，因为无法读取其中包含的VBA项目。只有在首次删除VBA项目时才能打开数据库。删除VBA项目会从模块，表单和报告中删除所有代码。您应该在尝试打开数据库并删除VBA项目之前备份数据库


我试图通过从此数据库导入所有内容来重新创建数据库，但没有运气。我也尝试过从谷歌和论坛搜索结果中提供的许多解决方案。


有没有人能解决这个问题？


有没有软件来解决这个问题？或者是否有一种简单的方法来重建数据库，同时维护VBA模块？


我将非常感谢您提供的任何帮助。


谢谢，

Nathan

I am trying to recover a database in Access 2007. I do not have a viable backup. The error message is:

"The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project"

I have tried to recreate the database by importing everything from this database with no luck. I have also tried many of the solutions offered on search results from Google and forums.

Does anyone have a solution to this problem?

Is there software to fix this? Or is there an easy way to rebuild the database while maintaining the VBA modules?

I would greatly appreciate any help that is offered.

Thanks,
Nathan

推荐答案

我假设您在第一次打开数据库时根据错误消息得到了这个消息？查看是否可以在按住Shift键的同时打开数据库。这将禁用任何尝试在启动时运行的代码/宏。我不确定这是否有帮助，但值得一试。

I assume based on the error message that you get this when you first open the database? See if you can open the database while holding the shift key down. This will disable any code/macro that would try to run on startup. I''m not sure if this will help or not, but it is worth a try.

基本上，你的VBA已被软管。

尝试打开文件按住shift键的同时...


这种情况​​经常发生在拥有两个不同版本访问权限的人打开相同的前端/数据库时（另一个成员遇到这种情况不久前） ： http：// bytes.com/topic/access/answer...ed-cannot-read


你试过反编译吗？

Basically, Your VBA is hosed.
Try opening the file while holding down the shift key...

This often happens when people with two different versions of access open the same frontend/database (another member ran into just this case not too long ago: http://bytes.com/topic/access/answer...ed-cannot-read

Have you tried to decompile?

我的2c值得。我有类似的经历，如果我的记忆是我的权利，它是一个特定形式的vba崩溃一切。我先导入所有的表，查询，模块等，然后将表单逐个变成新的确定罪魁祸首的数据库。从那天起，我总是将我的工作文件复制并粘贴到同一个文件夹中，然后再制作任何c hanges。祝你好运！

my 2c worth. I have had a similar experience and if my memory serves my right it was vba in a specfic form that crashed everything.I imported all the tables, queries,modules etc first, and then the forms one by one into a new database to identify the culprit. From that day i have always copy and pasted my working file in the same folder, before making any changes. good luck!

这篇关于其中包含的VBA项目无法读取的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！