Sending a NET SEND message

[PosseJohn]

I have utilized the code from http://www.pacificdb.com.au/MVP/Code/UsrMsg.htm
which allows sending a message to users of a DB.

I have this setup in a clean DB, no other code. When I copy it to another
DB that has extensive code, it fails to function (no pun intended).

Any brainiacs that can help?

 

[Alex Dybenko]

Hi,
this code uses ADO, and perhaps you don't have a reference to it - try to
add one

 

[PosseJohn]

I just scanned the very long list of libraries, I could not find one that
used ADO in the name description.

Did I miss it, or is it named something obscure?

Thanx.

 

[Douglas J Steele]

You're looking for "Microsoft ActiveX Data Object 2.x Library"

 

[Alex Dybenko]

The full name is Microsoft ActiveX Data Objects 2.x library

 

[PosseJohn]

You were correct, I have added reference to Microsoft ActiveX Data Objects
2.7 Library (msado15.dll), and the code now works.

Thank you for the idea.

 

[Secret Squirrel]

I'm new at this but would like to know how this works. How do I create these
messages? Does this code get created in a module?