访问ACCDE或MDE文件停止按钮工作 [英] Access ACCDE or MDE files stop buttons working

问题描述

您好，我发现之前有人在9月10日发帖（ http：// www。 thescripts.com/forum/thread705528.html ）似乎和我有同样的问题，但它从未解决。


我创建了一个包含很多导航的数据库使用按钮导致其他形式的页面。还有一些表单由组合框填充，您可以从下拉框中选择记录，并在表单上填写该记录的详细信息。这一切都在正常模式下运行良好。


但是当我制作MDE时（因为我使用Access 2007，但是我将数据库提供给2003的朋友，所以我一直在使用Access 2007年在2003兼容模式下）所有按钮都停止工作，组合框不再填充表格。我尝试制作一个ACCDE（升级到2007模式，然后进行转换只是为了看看MDE是否出错）但这也导致所有按钮停止工作。


这里是其中一个按钮的代码，例如：

展开 | 选择 | Wrap | 行号

解决方案

通常将数据库移动到另一台PC可能导致库链接丢失。

安装Access后，打开一些VBA代码（例如，按[CTRL + G]）并选择工具/参考。

每个以MISSING开头的库名。必须取消选中并且（例如微软DAO版本x.xx）必要时更换。


由于访问没有清理添加的库，通常不会有不必要的refenreces。

只需尽可能多地删除而不会执行错误调试/编译所有模块


对于Access 2007，所谓的受信任位置会产生另一个问题;。您需要创建一个文件夹（和/或它的子文件夹），以允许执行代码。激活Office按钮菜单上的[访问选项]按钮时，请参阅安全性部分。


Nic; o）

亲爱的Nic; o），


感谢您的帮助，但这个问题发生在我自己的电脑上，所以我没有移动电脑。我只是将完全工作的.mdb或.accdb转换为.mde或.accde，所有按钮都停止工作。我没有通过电子邮件发送最终版本，因为它在我自己的计算机上不起作用。


我查看了你描述的库部分并且没有丢失的部分，我创建了这个位置在哪里我存储我的文件信任并且这没有任何区别。


这似乎是由锁定产生的问题。将数据库设为.mde或.accde


你有任何其他想法，因为数据库目前无法使用，除非我把它作为设计交给我的朋友可编辑（我真的不相信他们，没有冒犯他们的PC技能！）


Lindsay

亲爱的Nic; o），


感谢您的帮助，但这个问题发生在我自己的电脑上，所以我没有移动电脑。我只是将完全工作的.mdb或.accdb转换为.mde或.accde，所有按钮都停止工作。我没有通过电子邮件发送最终版本，因为它在我自己的计算机上不起作用。


我查看了你描述的库部分并且没有丢失的部分，我创建了这个位置在哪里我存储我的文件信任并且这没有任何区别。


这似乎是由锁定产生的问题。将数据库设为.mde或.accde


你有任何其他想法，因为数据库目前无法使用，除非我把它作为设计交给我的朋友可编辑（我真的不相信他们，没有冒犯他们的PC技能！）


Lindsay

这是一个reeeeeeeeally远投，但尝试声明一个单独的变量对于每个使用实例： 的

展开 | <跨度类= codeLink 的onclick = 全选（本）;>选择 <跨度类= codeDivider> | <跨度类= codeLink 的onclick =自动换行（本）; >换行 | 行号

Hello, I found a previous posting by someone on the 10th Sept (http://www.thescripts.com/forum/thread705528.html) who seemed to have the same problem as me, but it was never resolved.

I have created a database with many navigation pages which lead to other forms using buttons. Also some forms are populated by combo boxes where you can select the record from a drop down box and it fills that record''s details on the form. This all works brilliantly in the normal mode.

However when I made an MDE (as I use Access 2007, but am giving the database to a friend with 2003 so I have been using Access 2007 in 2003 compatibility mode) all the buttons stop working and the combo box no longer populates the forms. I tried making an ACCDE (upgrading to 2007 mode and then converting just to see if it was the MDE making it go wrong) but that also resulted in all the buttons stopping working.

Here is the code for one of the buttons for example:

Expand|Select|Wrap|Line Numbers

解决方案

In general moving a database to another PC can cause Library links to get "lost".
When you have Access installed, open some VBA code (e.g. by pressing [CTRL+G]) and select Tools/References.
Each libraryname starting with "MISSING" must be unchecked and (e.g. microsoft DAO version x.xx) replaced when necessary.

As access doesn''t cleanup added libraries, often unnecessary refenreces are present.
Just delete as many as possible without getting an error executing "Debug/compile all modules"

For Access 2007 an additional problem arises with the so-called "trusted locations". You''ll need to make a folder (and/or it''s subfolders) trusted to allow code to be executed. See the Security section when activating the [Access Options] button on the Officebutton menu.

Nic;o)

Dear Nic;o),

Thanks for your help, but this problem happens on my own PC, so I have not moved PCs. I just convert my fully working .mdb or .accdb into an .mde or an .accde and all the buttons stop working. I have not emailed them the final version as it does not work on my own computer.

I looked in the libraries section you described and there were no missing ones, and I made the location where I store my file "trusted" and that made no difference aswell.

It seems to be a problem created by the "locking" of the database by making it an .mde or an .accde

Do you have any other ideas, as the database is unusable as currently stands, unless I give it to my friend as design editable (and I really don''t trust them with that, no offence meant about their PC skills!)

Lindsay

Dear Nic;o),

Thanks for your help, but this problem happens on my own PC, so I have not moved PCs. I just convert my fully working .mdb or .accdb into an .mde or an .accde and all the buttons stop working. I have not emailed them the final version as it does not work on my own computer.

I looked in the libraries section you described and there were no missing ones, and I made the location where I store my file "trusted" and that made no difference aswell.

It seems to be a problem created by the "locking" of the database by making it an .mde or an .accde

Do you have any other ideas, as the database is unusable as currently stands, unless I give it to my friend as design editable (and I really don''t trust them with that, no offence meant about their PC skills!)

Lindsay

This is reeeeeeeeally a long shot, but try declaring a seperate Variable for each instance of use:

Expand|Select|Wrap|Line Numbers

这篇关于访问ACCDE或MDE文件停止按钮工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！