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

Bill,

Thank you very much. I will try the IP approach.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform