>>>I need to modify a couple of tables residing on customer server. I connect to the server via VPN. I don't want to install a full version of VFP on the server. Does anybody know if there is an .EXE tool that I can copy to the custom server, run it there and open and modify (hack) some tables? I would copy the tables to my PC and modify on my PC but the files are quite big. If I don't find the right tool to do it on the server, I will have to copy the files back and forth.
>>>
>>>Thank you.
>>
>>If you are connecting via VPN then you should be able to use your VFP on your computer as long as you are connecting using an account with rights to the read/write the files.
>
>I do have rights to the server (full rights). But I am not sure how I would point to the server drive from my PC. For example, if I have Command prompt of my VFP open, how would I call "USE MYTABLE" where the MYTABLE reside on the server and not on a mapped drive. Are you suggesting that I can map the server drive to my PC? Then how?
>
>Thank you.

You should be able to map a drive or use a UNC as a direct path to the files. If you can find the UNC path to your file (ie \\servername\sharename\folder\subfolder\filename) you should be able to use it directly.

Depending on the VPN, you may not have DNS resolution in order to specify the server by name - instead you may have to use \\serverIPaddress\sharename\folder\subfolder\filename.

for example, to access a table on my network from my contractor VPN, you might use..

USE \\CURLYQLINK\Projects\VFP\COMPANYB\DATA\thistable.dbf exclusive

or, if DNS doesn't resolve CURLYQLINK, use the IP address instead..

USE \\10.0.0.251\Projects\VFP\COMPANYB\DATA\thistable.dbf exclusive