mscomm runtime problem

[Luka]

Hi everyone,

My db uses activex control and mscomm to communicate with external device. Db runs ok on access 2003 and 2007 version but i can't get it to run in access runtime 2007 (its on different computer). I tested external device on that computer and connection is ok. But access db giver me runtime error and then close.

Is it possible that this control doesn't work in runtime?

 

[Luka]

I found a solution.

For anyone using .ocx files in access. Here is what you need to do when you distribute your application:

On computer where you installing your app:

1. install vb runtime. You can get it on microsoft pages.
2. Copy your .ocx file to windows/system32 folder.
3. register .ocx file by running regsvr32 from command promt (regsvr32 is located in windows/system32 folder)
4. on internet find file called "vbctrls" download it, use right click on your mouse and press merge. That updates the registry.

If your code is ok and the references are set in your app then it should work.

Make system restore point before updating registry!

Have a nice day.

 

[boblarson]

Thanks for posting the answer Luka. I'm sure that will be most helpful to several forum members as they go on with A2K7.