数据库无法打开，因为其中包含的vba项目无法读取 [英] database cannot be open because vba project contained in it cannot be read

问题描述

创建.accde前端后，我的一些用户现在收到错误消息"数据库无法打开，因为VBA 其中包含的项目无法读取。只有在首次删除VBA项目项目时才能打开数据库......"

Upon creating a .accde front end, some of my users are now getting the error message "database cannot be open because VBA  project contained in it cannot be read. The database can be opened only if the VBA project project is first deleted..."

我做了一些研究并遇到了一篇kb文章
2533794  但是这篇文章似乎表明错误的原因是db在具有sp1的机器上编译，并且运行它的机器没有sp1（或者反过来）。 但是，IT人员向我保证所有已安装的
版本的Access都是SP1。 但是，机器和操作系统之间存在差异。 上次发生这种情况时，我通过在Windows 8计算机上进行编译然后将.accde分发给每个人来修复它，但是这个
时间我做了这个并且问题没有得到解决。 以下是我与该客户的工作流程。 我通过终端服务连接到XP机器。 我的工作是在XP机器上的Access 2010中。 我对前端进行了更改，然后
将这些更改传播给每个用户。  当我第一次更改为使用.accde而不是.accdb时，我们遇到了此错误，解决方案是登录到其中一台Windows 8计算机，创建.accde并将该文件传播给所有人。  
这一次，我做到了，我通过连接到连接到Windows 8的XP的终端服务测试了它。它工作了，然后我退出Windows 8机器，只是通过终端连接到XP服务并再次测试并且有效。 
以前，当我在XP操作系统中编译时，这会在Windows 8计算机上运行时给出上述错误。 
但是既然它有效，这就是在遇到同样问题之前解决的问题，
我很满意一切都很好。 但是，当用户直接从他们的计算机登录时，他们会收到上述错误。 
然后我将.accdb传播给每个用户，直到解决了这个问题，但我不知道如何解决它。 
有什么想法？

I did some research and came across a kb article 2533794  but this article seems to suggest that the reason for the error is the db is compiled on a machine with sp1 and the machine it is run on doesn't have sp1 (or the other way around).  However, the IT person assures me that all installed versions of Access are SP1.  However, there is a difference between the machines and that is the operating systems.  The last time this occurred, I fixed it by compiling on the Windows 8 machine and then distributing the .accde to everyone, but this time I did that and the issue was not resolved.  Following is the flow of my work with this client.  I connect to an XP machine via terminal services.  My work is in Access 2010 on the XP machine.  I make changes to the front end and then propagate those changes to each user.  When I first changed to use the .accde instead of the .accdb we got this error and the resolution was to log into one of the Windows 8 machines, create the .accde and propagate that file to everyone.  This time, I did that, I tested it via terminal services connected to XP connected to Windows 8. It worked, and then I logged out of the Windows 8 machine and was just connected to XP via terminal services and tested again and it worked.  Previously, when I compiled in XP operating system this would have given me the error mentioned above when running on Windows 8 machines.  But since it worked and this is how it was resolved before after encountering the same problem, I was satisfied that all was well.  However, when the users logged in directly from their machines they got the error above.  I then just propagated the .accdb s to each user until this is resolved, but I don’t know how to resolve it.  Any thoughts?

 

为了他人的利益，请在回答或帮助您找到答案时将帖子标记为已回答或有帮助。 ___"我们这样来探索月球，最重要的是我们发现了地球。" - 比尔安德斯，
阿波罗8。

For the benefit of others, please mark posts as answered or helpful when they answer or assist you in finding the answer. ___ "We came all this way to explore the Moon, and the most important thing is that we discovered the Earth." - Bill Anders, Apollo 8.

推荐答案

你好suzyQ，

Hi suzyQ,

感谢您的帖子。

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