以ACCDE格式禁用VBA代码 [英] VBA code disabled in ACCDE format

查看:128
本文介绍了以ACCDE格式禁用VBA代码的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

大家好。

当我制作ACCBD(Access 2007)数据库的ACCDE格式时,会出现上述情况。这意味着,我的代码执行的某些命令在ACCDE中不起作用,而它们在ACCBD中完美运行。

附加的屏幕截图是打开ACCDE格式时弹出的警告消息。


如何纠正与之相关的错误/故障,从而使我的VBA代码能够在ACCDE中运行?


..

否则,我可以选择禁用对表单和报表中的设计视图,数据表视图的访问,并隐藏一些对象(表,查询,宏,模块),包括导航窗格 - 作为如果以上情况不可能在我的最后,最后的手段。


谢谢。

Hi all.
The above occurs, when I make an ACCDE format of my ACCBD (Access 2007) database. This means, some commands to be executed by my code are non-functional in the ACCDE, while they work perfectly in the ACCBD.
The attached screenshot is the warning message that pops up on opening the ACCDE format.

How do I go about rectifying the error/ malfunction associated with it, hence enabling my VBA code to run in the ACCDE?

..
Otherwise, I may opt to disable access to design view, datasheet view in forms and reports, and hide some objects (tables, queries, macros, modules), including the navigation pane - as a last resort if the above is not possible on my end.

Thank you.

附加图像
截图2015-05-25 16.28.50.png (32.2 KB,963 views)
Attached Images
Screenshot 2015-05-25 16.28.50.png (32.2 KB, 963 views)

推荐答案

你有安装了Office 2007 Service Pack 2(链接到MS)


此线程: http:// bytes .com / topic / access / answer ... ecurity-notice


我安装了Office 2007 Service Pack 3.

---


我已经实现了Registry Edit,它消除了安全通知消息(包括accde和accdb)。但是,我的代码仍然在accde中被禁用。

---


是否意味着安装了Service Pack 3功能会在accde中禁用我的代码?


在SP2的链接上,我需要让我们的IT经理允许我在我的电脑上安装它(如果他可以将它安装在将运行的PC上)数据库)。我的工作主要是在公司的数据库中。
I have Office 2007 Service Pack 3 installed.
---

I''ve implemented the Registry Edit, which eliminated the Security Notice message (both in accde and accdb). However, my code still disabled in accde.
---

Could it mean that, features Service Pack 3 installed disables my code in accde?

On the link to SP2, I''ll need to ask our IT Manager to allow me to install it on my pc (also, if he could install it on the pcs that will run the database). My work is mostly on databases in the Firm.


如果您安装了Service Pack 3,那么您应该没问题...

由于问题,我们跳过了Office2007这样我就得做一点挖掘。
if you have service pack 3 installed then you should be ok...
We skipped Office2007 because of issues like this so I''ll have to do a little digging.


这篇关于以ACCDE格式禁用VBA代码的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆