How to know path of a Special Folder in a network?

[Mota]

Hi;
In my back end,i have a function that asks a path from user and copies Front
End file to the specified path.This is done for each workstation in our the
network.I want to put an icon on the desktop of the specified
machine.So,Computer name can be extracted from the path user
selects.Obviously when i use this code to get Desctop path:
Set Shell = CreateObject("WScript.Shell")
DesktopPath = Shell.SpecialFolders("Desktop")
returned string is the Desktop path of the current machine,usually server
(where the function is running),but i need desktop path of another
workstations,based on the path user specifies for copy a Front End
file.So,how to find path of the Desktop folder of another computers,while my
code is running in server?Is there any solution?
Thank you for all your helps.

 

[Douglas J. Steele]

Ignoring the fact that backends shouldn't have code in them, be aware that
even though your database may exist on the server, the code doesn't run
there: it runs on the workstation of the current user.

 

[Mota]

Ok,Supposing that i put that code in front end file,is there a way to know a
desktop path of the other computers in a network,while my code is running in
another terminal?
Thank you for your attention.

 

[Paul Overway]

You would have to write a record in a table or file with the machine name
and the path, and then read the table or file. But the best solution is to
create a proper installer to install the file and create the shortcut. What
you're trying to do doesn't make much sense.

 

[Mota]

Have some troubles with untrined users for installing program by them.I
preffer to install it from one computers to the others.Now i can do it
well,just need a way to get a Desktop path (to put an icon on it) of the
other machines from behind one of them,and not the program path.
Thank you so much for your help.