Dear Sir,
I am trying to access to a remote server to copy a file to my local pc, can i know the correct code?

In the beginning of the code, i use this

conn.open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\webs\school.com\college.mdb"

and then use SQL to get a table from college.mdb 


Now i want to copy the file college.mdb to my C:\WINDOWS\Desktop\

Part of my code is like this: what is the correct code?
=====================================
Set FSO = CreateObject("Scripting.FileSystemObject")

Call FSO.copyfile("d:\webs\school.com\college.mdb", C:\WINDOWS\Desktop\")

=================================

i know the code above in blue color is wrong, what is the correct way to specify the path to a remote server?


hope u can help, thanks

cheers,
patrick