[求助]我会疯了，好不容易写的代码，竟然在其他机上用不了！

AZA

我的电脑是XP SP1,Access2003的，其他电脑是SP2 Access2003.

打开文件的时候，错误提示如下：

Visual Basic for Applications (VBA) encountered a problem while attempting to access a property or method. The problem may be one of the following:
·A reference is missing.
·For help restoring missing references, see the Microsoft Knowledge Base article 283806.
·An Expression is misspelled.
·Check all expressions used in event properties for correct spelling.
·A user-defined function is declared as a sub or as a private function in a module.
·Expressions can resolve a user-defined function only if the function is declared as one of the following:
·A public function in a module
·A public or private function in a code module of the current form or report
·Security in Access is set to Medium or High and the Microsoft Jet 4.0 SP8 update is not installed.
·A more recent verion of Jet 4.0 must be installed for Access to function properly when security is set to Medium or High. To obtain the latest version of Microsoft Jet, go to Windows Update.


耗时几个月的成果难道要泡汤！？高手们，救救我吧！

andymark

我这里可以,按上面提示检查一下原因

AZA

谢谢！

能帮忙看看代码有什么需要改进的地方吗？

很奇怪，有些机上完全可以（都是XP SP2 Access2003），有些却不行，这是否跟登录Windows的权限有关？我们公司是用Windows Professional XP的操作系统。

[此贴子已经被作者于2006-10-19 12:32:28编辑过]

wuaza

C:\WINDOWS\system32\stdole2.tlb

C:\WINDOWS\system32\iashlpr.dll

C:\WINDOWS\system32\iasrad.dll

以上引用文件你检查一下，缺失的话去拷贝一个。

AZA

试过了，我甚至把那三个文件复制过去并覆盖了原来的文件，但还是不行啊,sigh……

AZA

高手们，有其他办法吗？

AZA

up!!!!!

andymark

以下是引用AZA在2006-10-19 11:36:00的发言：


我的电脑是XP SP1,Access2003的，其他电脑是SP2 Access2003.

打开文件的时候，错误提示如下：

Visual Basic for Applications (VBA) encountered a problem while attempting to access a property or method. The problem may be one of the following:
·A reference is missing.
·For help restoring missing references, see the Microsoft Knowledge Base article 283806.
·An Expression is misspelled.
·Check all expressions used in event properties for correct spelling.
·A user-defined function is declared as a sub or as a private function in a module.
·Expressions can resolve a user-defined function only if the function is declared as one of the following:
·A public function in a module
·A public or private function in a code module of the current form or report
·Security in Access is set to Medium or High and the Microsoft Jet 4.0 SP8 update is not installed.
·A more recent verion of Jet 4.0 must be installed for Access to function properly when security is set to Medium or High. To obtain the latest version of Microsoft Jet, go to Windows Update.

       这不是提示了你问题所在吗,一步一步排除呀

Benjamin_luk

1。将可在 SP2 Access2003中运行的MDB编译一下，转为2002或2000版本后再试试

2。检查各PC中  C:\Program Files\Common Files\Microsoft Shared\VBA 下的文件是否完整

[此贴子已经被作者于2006-10-20 20:08:35编辑过]

AZA

有些机上可以，但是大部分机上都不行，都提示了那个错误。

盼望高手能帮忙完善代码，谢谢拉！！