Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1406
  • Last Modified:

Winsock in MS Acess 2010 64-bit

I don't seem to have a Winsock ActiveX control, but I do see Winsock (not "Winsck") in the VBA object browser with all the ActiveX events, properties and methods I'm used to from 2003 version.  I just don't know how to use it in my VBA code.  I've registered mswinsck.ocx (V6, SP6) in sysWOW64, but can't seem to get the control onto a form.  Is there a native 64-bit implementation of Winsock?  If so, how do I use it?

Thanks!
0
jriggin
Asked:
jriggin
  • 2
  • 2
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
From what I know, there is only a 32 bit version of that control.  You must be using a 32 bit version of Office to use it.

Jim.
0
 
jrigginAuthor Commented:
If that is true, how does one go about TCP communication in MS Access x64?
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<If that is true, how does one go about TCP communication in MS Access x64? >>

 You'd have to make direct calls to the Windows API's.

  The other option would be to find a 3rd party control to replace it, but I don't know of any off-hand.

  There are very few 64 bit versions of 3rd party controls.   64 bit is simply not catching on.

  In fact unless you need very large spreadsheets (about the only pro to using Office in a 64 bit version), even Microsoft is still recommending to sticking with 32 bit versions for this very reason.

Jim.
0
 
jrigginAuthor Commented:
sorry for the delay.  i was hoping that someone would chime in with a happier answer.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now