Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Winsock in MS Acess 2010 64-bit

Posted on 2013-05-30
4
Medium Priority
?
1,398 Views
Last Modified: 2013-06-12
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
Comment
Question by:jriggin
  • 2
  • 2
4 Comments
 
LVL 58
ID: 39208568
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
 
LVL 1

Author Comment

by:jriggin
ID: 39228669
If that is true, how does one go about TCP communication in MS Access x64?
0
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 39229089
<<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
 
LVL 1

Author Closing Comment

by:jriggin
ID: 39242272
sorry for the delay.  i was hoping that someone would chime in with a happier answer.
0

Featured Post

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question