Solved

Winsock in MS Acess 2010 64-bit

Posted on 2013-05-30
4
1,215 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 57
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 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

705 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now