无法打开数据库，因为无法读取其中包含的VBA项目。 [英] Database cannot be opened because the VBA project contained in it cannot be read.

问题描述

我的网络上有一个拆分数据库，最近（过去几周），它似乎随机地向用户提供此错误：

由于VBA，无法打开数据库其中包含的项目无法读取。只有在首次删除VBA项目时才能打开数据库。删除VBA项目将从模块，表单和报告中删除所有代码。然后它讨论了备份。


唯一能够解决错误的方法是单击OK（取消不做任何事情），然后打开数据库而不用任何代码（所以它没用）。


我已多次用Google搜索此问题并遇到此问题：http：//support.microsoft.com/kb/2533794

我已按照它的建议进行了反编译，然后在它再次中断之前再运行一两天并给出相同的错误。我也反编译，紧凑和修复，重新编译...尝试了各种形式 - 但没有什么工作很长时间。


有谁知道这个问题的长期解决方案？


谢谢!!

I have a split database on our network and lately (the past several weeks), it''s been seemingly-randomly giving this error to users:
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 the modules, forms and reports. and then it talks about making a backup.

The only way to get past the error is to click OK (cancel doesn''t do anything), and then it opens the database without any code (so it''s useless).

I''ve Googled this problem many times and came across this: http://support.microsoft.com/kb/2533794
I''ve decompiled, as it recommends, and then it works for another day or two before it breaks again and gives the same error. I''ve also decompiled, compact & repair, recompiled... tried various forms of that - but nothing works for very long.

Does anyone know of a long-term solution to this problem?

Thanks!!

推荐答案

我遇到了与Access 2010类似的奇怪问题（我不确定你使用的是哪个版本）。有时我只是将所有查询，表单，报告等复制并粘贴到另一个全新的数据库文件中。


如果这不起作用，那么尝试一次复制一个对象，直到找到导致问题的对象，然后从头开始重做。


此外，您的前端存储在哪里？

I have had similar weird problems with Access 2010 (I''m not sure which version you are using). Sometimes I have been successful with just copying and pasting all the queries, forms, reports, etc. into another brand new database file.

If that doesn''t work, then try copying one object at a time over till you find which object is causing the problem and then redo it from scratch.

Also, where is your front end stored?

您是否已将所有PC上的所有Access安装升级到最新的Service Pack。这是我对链接文章的阅读。在此之前，这些错误可能会重现。

Have you upgraded all your Access installs on all the PCs to the latest Service Pack. That''s my reading of the linked article. Until this is finished these errors are likely to reccur.

我正在运行Access 2010，SP1。几个月前我们整个公司都升级到了这个 - 具有讽刺意味的是，这与我们开始收到这些错误的时间差不多（我之前在Access 2007上）。


后端和前端都在我们的网络上。我们有超过5,000名员工需要访问这个数据库，所以试图让每个人都把前端放在他们的本地计算机上是没有意义的。


我猜如果您真的认为这会有所帮助，我将不得不尝试将所有内容复制到新数据库中。我犹豫不决，因为我有大约100个查询和另外30个左右的表单和报告，然后是一些链接到后端的表和其他链接到SQL数据库的表。


感谢您的帮助。

I''m running Access 2010, SP1. Our entire company was upgraded to this a couple months ago - which, ironically, is about the same time we started getting these errors (I was previously on Access 2007).

Both the back end and the front end are on our network. We have over 5,000 employees who need access to this database, so it just didn''t make sense to try to get everyone to put the front end on their local computers.

I guess I''ll have to try copying everything over into a new database, if you really think that will help. I hesitate because I have about 100 queries and another 30 or so forms and reports, and then some tables that are linked to the back end and other tables that are linked to a SQL database.

Thanks for your help.

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