Forum Index > Comm64 and MS Access

By: Jeff Grammer Posted on: Jul 2 2012 at 02:40:28 PM
How can I use this control in MS Access 2010? I have no problem with sComm32.OCX.
But I expect to go 64 bit soon and don't want to buy sComm32 for just a short period of time.

By: Support Posted on: Jul 4 2012 at 01:27:17 PM
To be honest I've never tried it with 64bit version of ms access. It would depend on whether you can use "any" managed .net assemblies in access 2010 VBA. I don't think you can.

By: Guest Posted on: Jul 9 2012 at 02:06:21 PM
I simply looked in the "Icon" of the controls in the Design tab on MS Access 2010. I did try to find it and map it in the Active X controls. No luck there either. I could make a stand alone app in VB 2010 linked to a MS Access database but would prefer not to. I just converted all the code from a VB 6 app to VBA for MS Access 2010.

By: Support Posted on: Jul 10 2012 at 02:43:40 AM
Access 2010 VBA is still firmly rooted in the 32bit world of COM/ActiveX

Comm64 is not an activeX control. It will not appear in any list of COM/ActiveX controls and can not be used as an ActiveX control.

It is a managed .Net assembly. I don't think Access 2010 is capable of using any modern .net assembly. Access 2010 VBA still requires old COM (ActiveX) components.


Probably why Access 2010 installs by default in 32 bit mode even on 64bit computers. You have to dig a little deeper to get the 64bit version installed but then that would probably prevent any serious VBA development.

By: Support Posted on: Jul 10 2012 at 04:25:34 AM
I suppose it would be possible for us to expose the .Net assembly to COM but that would be basically wrapping it up like an ocx in which case you'd be better off just using our SComm32.OCX

By: Guest Posted on: Jul 11 2012 at 01:06:29 PM
Ok, I guess we will buy the scomm32 and hope it works when we go 64. It is not all that expensive anyway.
Thanks

By: Guest Posted on: Jul 11 2012 at 02:37:48 PM
I don't think you'll be going 64. I don't think VBA will build any true 64 bit code. It'll simply run in WOW64

 

Reply - add comment to this topic
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected
  Topic:- Comm64 and MS Access

Your Name


 


Forum scripts and databases - Copyright (c) 2009 - 2012 AxCoL.com