Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tool to open and modify DBF file?
Message
From
02/12/2008 21:09:24
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01365258
Message ID:
01365297
Views:
17
>>>>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

Hmm, if the tables are large this could be painfully slow. People get used to LAN speeds of 100Mbit/s or even 1Gbit/s when accessing Fox tables. A lot of VPNs have effective throughput only a few percent of that e.g. 1 to 5 Mbit; every operation could take 20, 100 or even more times longer.

I think Dmitry should look hard at options for getting a remote console, if at all possible (RDP, TS, VNC etc.)
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform