Socket tcp communication for Access 64bit - what we can do?

[amorosik]

What's the best way to implement TCP socket communication for 64-bit Access?
The winsck.ocx library works fine in a 32-bit development environment, but what can I do to use 64-bit Access?
I saw this code on Spiceworks
Have any of you used it with good results?

 

[Albert D. Kallal]

What's the best way to implement TCP socket communication for 64-bit Access?
The winsck.ocx library works fine in a 32-bit development environment, but what can I do to use 64-bit Access?

I would suggest using the vb.net sockets, and then call that code from VBA. It's not clear if you using the ActiveX controll (dropped into a Access form), or using the TCP library direct from VBA?

Over the years, going back to VB5, VB6 days, and even now in .net?
I never had to use TCP library.

So, depending on what you need, you may well be able to write such code in VB.net, and simply call that code from VBA.

The nice part is:
You don't need a VBA reference.
You have x32 and x64 bit support...

So, it kind of depends on what your VBA code now looks like - and depending on what you need, then I suggest calling such code from VBA...

Perhaps you post a wee bit of code of what you VBA did/does.

R
Albert.