Solved

Using Winsock ActiveX control with Access 2010

Posted on 2013-11-05
3
1,052 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
  • 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 84

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

777 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