mscomm cotrol for ms access 2007

[ZOR]

Is there any equivelant code/control for using mscomm control in Access 2007. User wants serial port communication from Access database. Thanks

 

[johnwm]

This is the VB6 forum - VB6 has an MSComm control. If you want to code in Access VBA you will do better in forum705

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[ZOR]

Thanks, I put the thread in here knowing it's a VB/C+ object as Access users may not have come in contact with it. Regards

 

[tedsmith]

Vb6 Comms control works perfectly with earlier Access versions OK. Are you saying it doesn't with Access2007?

 

[dilettante]

It is possible to use controls like this one with Office in a machine with the VB6 development package installed. It is not recommended or supported however, and can't legally be deployed to other systems.

In the past the answer was to acquire an Office Developer Edition for the Office version you were using. After Office XP (2002) this is no longer an option.

Now you need to get the appropriate VSTO/VSTA development kit that corresponds to Office 2003 or 2007. But these do not include development licenses for the licensed Microsoft ActiveX controls.

INFO: Migrating from Microsoft Office XP Developer

Thus there appears to be no legal way to use such controls in an Access application after Access 2002. Note that finding a hack that makes it work doesn't make it legal.

 

[ZOR]

Many thanks. Bill Gates wins again.