Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1434
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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