Solved

Using Winsock ActiveX control with Access 2010

Posted on 2013-11-05
3
1,117 Views
Last Modified: 2013-11-20
I just upgraded a working Access 97 database to version 2010. The database has a Winsock Control Version 6 that sends messages to another application. The protocol property is set to UDP.
When I run this code:
    Request = "Weight Request " & "Wood Fiber"
    udpPeerA.SendData Request
I get this error message:
Run time error "10014"
Invalid argument

Any ideas?

TIA
John
0
Comment
Question by:JohnFra
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 22

Accepted Solution

by:
Kelvin Sparks earned 250 total points
ID: 39626341
or  bit Access . Most Active X controls are  bit and will not work with Access  64 bit.  If this is the case you need Access  bit OR source a bit control.


Kelvin
0
 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 39626979
You can try reinserting the control on the form, to insure the references are working correctly.

But understand that Access does not properly support the overwhelming majority of them (even those that come from Microsoft). Some early version of Access included a set of controls that worked with Access, but that stopped around Access 2002. Newer versions don't support them, and as kelvin indicates, the version of Office being used, and the operating system, can often cause these sorts of issues.

Bottom line - rewrite the app to remove the need for this control, or move the app to a more compliant environment.
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 39627978
Further to my post - for some reason some of the numbers did not post. 32 or 64 bit? Most Active X controls are 32 bit and will not work with Access  64 bit.  If this is the case you need Access 32 bit OR source a 64 bit control.

Kelvin
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses

627 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