Winsock? Wherefore Art Thou? "There is no object in this control"

[tudor]

I have an Access 2003 ADP application that had/has a form with a Winsock
control in it. All worked brilliantly until about 10 days ago (XP, Vista,
2003 machines in multiple locations): "There is no object in this control".
We haven't made ANY changes to the application in over a year, so I strongly
suspect that Windows Update is the culprit.
I tried to readd the Winsock control to the form using Insert>ActiveX
Control>Microsoft WinSock Control, version 6.0 and received "[Application
Name] doesn't support this ActiveX Control". I tried to unregister and
reregister c:\windows\system32\mswinck.ocx and then tried to readd the
control - that didn't work.
The control on the form is OLE Class: Winsock, Class: MSWinsock.Winsock.1 -
and it looks fine.
And just to make sure the ADP wasn't the issue, I created a blank .mdb
database, created a new form, inserted the Winsock control and got:
"Microsoft Office Access doesn't support this ActiveX control."
Has anyone else run into this issue? This is a major drag... our application
is totally cut off from a bunch of other systems without winsock support.

 

[tudor]

anyone else have this issue too?

 

[Tony Toews [MVP]]

I have an Access 2003 ADP application that had/has a form with a Winsock
control in it. All worked brilliantly until about 10 days ago (XP, Vista,
2003 machines in multiple locations): "There is no object in this control".
We haven't made ANY changes to the application in over a year, so I strongly
suspect that Windows Update is the culprit.

You are correct in suspecting Windows Update.

KB960715
http://www.microsoft.com/technet/security/advisory/960715.mspx

Now the problem, or so my understanding goes, is that it's somewhat
difficult to update the client systems without the use of VB6 to
create an install package. You basically need to have an
administrator copy the OCX onto the client PC and register it. Which
is, of course, a pain.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/