English 中文(简体)
在执行过程中使用任何代码的起步
原标题:accde ran using runtime stops any code from executing

I ve upgraded an old access 2003 database to access 2010. The original database was split with an access front (installed to the clients) and back end (residing on the server). The new database uses access for the front end but the back end has been moved to SQL server.

Once it was finished I created an accde file and packaged that up in an installer to distribute it to all the client pcs. The installer creates a desktop shortcut that runs access 2010 in runtime mode and starts the front end database.

我在当地对它进行了测试,在我的发展动态中,一切都是罚款的。 但是,在测试客户码(安装了2010年办公室)时,在开放数据库时出现错误,停止执行所有代码。 这显然是一大错误,阻止任何人使用数据库。

错误

The expression On Current you entered has the event property setting produced the following error
The expression may not result in the name of a macro, the name of a user defiend function, or event procedure.

我已确保数据库位于一个可信赖的地点,并用所有宏观方法对其进行审判,但这种错误仍然存在。 在创建中学之前,我还确保了所有法典的汇编。

我用人工复制了在干净测试板上的自动取款机,以检查它是否与安装商有问题,甚至完全开放(不使用/超时旗)的自动取款机。 如果我向客户寄送了acc子,那么它会进行罚款,但显然会分发acc子,以安全的方式管理数据库。

我也试图制造一个空白的2010年干 d,并从更新版本中进口所有物体(这是一个折射文件,被改装成acc),以检查其不成问题,即从原干.转换到原样子的渠道——仍然有同样的错误。

任何人是否在我身上发现过这一错误,我很 well,而且确实 st。

EDIT:在测试客户的pc I上玩.后,我注意到,如果一开始输入acc子,然后将它作为acc子予以节省,就将翻印已安装的版本,那么它就会做罚款。 但是,这显然使安装工作大增,使所有客户都无法自动安装。 因此,它本身并不是一个可行的解决办法,希望它能把人置于正确的方向。

EDIT2:我还检查并证实,所有参考资料都是无端的电压/电荷/电荷,并出现在测试客户的板上。

最佳回答

This does sound a like a typical broken reference issue.

I would ensure that the VBA references are at a absolute min here. (on your dev machine, create a blank accDB file, and then in the VBA editor look at the default references – that s what you want for your production accDB that you will then compile into a accDE).

我还愿考虑在您的六氯苯乙胺上做一手工作。

而且,SP1办公室的更新也给VBA腐败带来问题。 如果您的参考文件是ok(您正在使用对字面/外观的自动化的延迟约束力),那么我会考虑在安装SP1之后,ALSO在2010年安装VBA热装置。 因此,用间谍1+代码热点进行试验。

VBA hotfix here: http://support.microsoft.com/kb/2596585

以上是新情况,从25岁开始,但你希望确保你首先检查/测试其他步骤,否则你就会陷入一场野 go,使你在此感到更加悲痛。

问题回答

暂无回答




相关问题
Handling no results for docmd.applyfilter

I have an Access app where I use search functionality. I have a TextBox and a Search Button on the form, and it does a wildcard search of whatever the user enters in the TextBox, and displays the ...

access query to filter and combine count

i have two access tables tableA num count 1 7 2 8 3 9 4 9 5 13 6 6 tableB num count 0 1 1 14 2 12 3 5 4 5 5 11 6 5 how can i create an access query that ...

How to show File Picker dialog in Access 2007?

I want to show a dialog where the user can pick a file, click OK, and then the path to the file will be saved in the database. I have just one problem, I can t figure out how tho show the dialog ...

MS Access: list macro from VBA

I have to deal with a few macros (not VBA) in an inherited Access application. In order to document them, I would like to print or list the actions in those macros, but I am very dissatisfied by ...

Returning row number on MS Access

I have 4 tables, from which i select data with help of joins in select query...I want a serial no.(row number) per record as they are fetched. first fetched record should be 1, next 2 and so on... In ...

热门标签