Multi User.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Db_Stuff - 24 Oct 2005 14:33 GMT

I would like to know if there is a way to retrieve the name of any computer
that is connected to an access database that is residing on the server. And
if so, how do I go about performing this action? Any help in this area will
be greatly appreciated.

Thanks

Reply to this Message

Rogelio Pérez - 24 Oct 2005 15:50 GMT

>I would like to know if there is a way to retrieve the name of any computer
>that is connected to an access database that is residing on the server. And
>if so, how do I go about performing this action? Any help in this area will
>be greatly appreciated.
>
>Thanks

HI
Try This
Function CompName()
Dim WshNetwork
Set WshNetwork = CreateObject("WScript.Network")
CName = WshNetwork.computername
MsgBox CName
End Function

Reply to this Message

Douglas J. Steele - 24 Oct 2005 22:23 GMT

>>I would like to know if there is a way to retrieve the name of any
>>computer
[quoted text clipped - 14 lines]
> MsgBox CName
> End Function

Or, likely more efficient (since you don't have the overhead of loading
WScript.Networks) is the API approach illustrated in
http://www.mvps.org/access/api/api0009.htm at "The Access Web"

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

Reply to this Message