Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1261
  • Last Modified:

Using Winsock ActiveX control with Access 2010

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
JohnFra
Asked:
JohnFra
  • 2
2 Solutions
 
Kelvin SparksCommented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
Kelvin SparksCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now