vba Windows 7 64 位上的 Microsoft Access 2010 和 MSCOMM32.ocx

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/11988971/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-11 17:20:08  来源:igfitidea点击:

Microsoft Access 2010 on Windows 7 64-bit, and MSCOMM32.ocx

vbax86-64ms-access-2010mscomm32

提问by Lil' Bits

Over the weekend, I had a hard drive failure on my business' POS & database computer. We have an Orbit Metrologic scanner hooked up to it via USB, and it's emulated for comm port COM3. The scanner works, and I was able to restore our database completely, except that our scanner is not able to communicate with Access 2010. Before we ran the 32-bit version of access, however this time I've downloaded the 64-bit version of access, seeing as we have a 64-bit machine.

上周末,我公司的 POS 和数据库计算机出现硬盘故障。我们有一个通过 USB 连接到它的 Orbit Metrologic 扫描仪,它被模拟为通信端口 COM3。扫描仪可以工作,我能够完全恢复我们的数据库,只是我们的扫描仪无法与 Access 2010 通信。在我们运行 32 位版本的 access 之前,但是这次我下载了 64 位版本访问,因为我们有一台 64 位机器。

Things I have done:

我做过的事情:

  • Registered MSCOMM32.ocx with Regsvr32 in SysWOW64 (the same one from the failed hard drive, I was able to boot to a linux live CD and extract it)
  • Disabled the MSCOMM32.ocx Windows 7 Kill-Bit using ADM.exe
  • Enabled all ActiveX controls to run without question in the trust center
  • Registered MSCOMM32.ocx in the VBA References
  • 在 SysWOW64 中使用 Regsvr32 注册了 MSCOMM32.ocx(与故障硬盘驱动器中的相同,我能够启动到 linux live CD 并解压缩它)
  • 使用ADM.exe禁用 MSCOMM32.ocx Windows 7 Kill-Bit
  • 启用所有 ActiveX 控件在信任中心中毫无问题地运行
  • 在 VBA References 中注册了 MSCOMM32.ocx

Can MSCOMM32.ocx work in a 64-bit enviornment? Or will I have to revert to 32-bit access?

MSCOMM32.ocx 可以在 64 位环境下工作吗?还是我必须恢复到 32 位访问?

采纳答案by Lil' Bits

The solution to this particular problem was solved by uninstalling the 64-bit version of Microsoft Access and re-installing the 32-bit version. The control was recognized right away.

此特定问题的解决方案是通过卸载 64 位版本的 Microsoft Access 并重新安装 32 位版本来解决的。控制立即被识别。