WINSOCK API with Access 97

[The Frog]

Hi Everyone,

I need a little help in shift an application away from the ActiveX
stuff to the full Winsock API. I am having a little trouble getting my
head around this, and as a result I seem to be getting more and more
confused with what I am doing.

Basically I am looking to create a class module in Access 97 that I
can use to handle network functions for TCP/IP and UDP/IP. I really
want to get away from any dependencies, as this network seems to have
its machines played with daily by the IT 'administrators'.

I am not used to mucking about with the windows API's, but have done
so a few times in the past - I do not consider myself strong in this
area at all. I have scoured the newsgroups looking for some applicable
sample code, likewise with google, but I cant seem to make head or
tail of it.

Does anyone know of a working link to a tutorial that could teach me
what I need to know to effectively use the Winsock API?

Cheers

The Frog

[Chuck Grimsby]

I've never found *one* good one that will teach you everything. Indeed
that may just be too much to hope for!

I'd recommend starting with a specific task and use the VB examples at
Randy Birch's site <http://vbnet.mvps.org/to figure out how to do
whatever it is you want to do.

Just remember that Randy's site is for VB, not VBA, so the code samples
may take a bit of changing to make them work. (And yes, they *do* work,
and you can use the APIs directly.)
The Frog wrote:

Hi Everyone,

I need a little help in shift an application away from the ActiveX
stuff to the full Winsock API. I am having a little trouble getting my
head around this, and as a result I seem to be getting more and more
confused with what I am doing.

Basically I am looking to create a class module in Access 97 that I
can use to handle network functions for TCP/IP and UDP/IP. I really
want to get away from any dependencies, as this network seems to have
its machines played with daily by the IT 'administrators'.

I am not used to mucking about with the windows API's, but have done
so a few times in the past - I do not consider myself strong in this
area at all. I have scoured the newsgroups looking for some applicable
sample code, likewise with google, but I cant seem to make head or
tail of it.

Does anyone know of a working link to a tutorial that could teach me
what I need to know to effectively use the Winsock API?

Cheers

The Frog

[The Frog]

Thanks Chuck,

What an amazing resource for API information. Muchly appreciated.
Although there is no real tutorials here for the Winsock API there is
certainly enough code examples and sample projects to figure it out.
Bookmarked this site - definitely a keeper.

Thanks Chuck,

The Frog

[CDMAPoster]

On Oct 1, 9:10 am, The Frog <[e-mail]:

Hi Everyone,

I need a little help in shift an application away from the ActiveX
stuff to the full Winsock API. I am having a little trouble getting my
head around this, and as a result I seem to be getting more and more
confused with what I am doing.

Basically I am looking to create a class module in Access 97 that I
can use to handle network functions for TCP/IP and UDP/IP. I really
want to get away from any dependencies, as this network seems to have
its machines played with daily by the IT 'administrators'.

I am not used to mucking about with the windows API's, but have done
so a few times in the past - I do not consider myself strong in this
area at all. I have scoured the newsgroups looking for some applicable
sample code, likewise with google, but I cant seem to make head or
tail of it.

Does anyone know of a working link to a tutorial that could teach me
what I need to know to effectively use the Winsock API?

Cheers

The Frog

If you're not in a hurry (the archive site is understandably slow) you
can try:

http://web.archive.org/web/200504130...p.com/winsock/

James A. Fortune
CD********@FortuneJames.com

[Larry Linson]

"The Frog" wrote

What an amazing resource for API information.

You want to know what's _really_ amazing? Randy Birch was not reawarded MVP
and, as of Oct. 1, 2007, is no longer an MVP.

Larry

[The Frog]

Hi Larry,

That seems to me to be one of the dumbest things. Why on Earth would
this person not be awarded MVP status for that obvious depth of
knowledge and sheer experience?

This has seriously devalued the MVP status to me. Is this because of
the shift to a more .Net language focus? It is certainly possible to
approach these tasks through the .Net frameworks, but still there is a
dependancy issue in having the framework in the first place. I dont
know if Office 2007 installs a .Net framework (assuming it is not
already there), but I do know that in my company there is no .Net
installation deliberately - the IT group control it this way for
whatever their reasons. I still see value in working the API's and I
cant see any reason at this stage to devalue that kind of knowledge -
if this is indeed what has taken place.

Just my two cents worth.

Cheers

The Frog

[The Frog]

Hi CD,

Thanks for this, I was wondering where this site has gone. It now only
exists in the Way Back machine.......... Thanks for the link, it is
another fantastic resource for working the Winsock API. Much
appreciated.

Cheers

The Frog.

I wonder what else is in that machine........:-)

[CDMAPoster]

On Oct 4, 4:48 am, The Frog <[e-mail]:

Hi CD,

Thanks for this, I was wondering where this site has gone. It now only
exists in the Way Back machine.......... Thanks for the link, it is
another fantastic resource for working the Winsock API. Much
appreciated.

Cheers

The Frog.

I wonder what else is in that machine........:-)

In addition to the dots you need some whirling noises :-).

James A. Fortune
CD********@FortuneJames.com