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
Microsoft Access 2010 on Windows 7 64-bit, and MSCOMM32.ocx
提问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 位版本来解决的。控制立即被识别。