>Can I open (and update) table on another location without opening their database? For example
>
>

>FirstPath = "C:\Program"
>SecondPath = "Z:\Sample"
>

>
>I want to update table (which is sane structure) on secod location with data on a first location via VPN connection.
>Openning table on a second location takes some time and I want to shrink that time for openning.
>Table is with about 1000 records. I can use it as a local table.
>Database name is a same on both location. How can I close second database after transaction below?
>
>

>SET DEFA TO C:\PROGRAM
>SELE 0
>USE SecondPath + "SampleTable" ALIAS SecondTable
>
>SELE 0
>USE SampleTable
>SET RELATION TO Id INTO SecondTable
>
>SCAN
>   REPLACE SampleTable.FieldValue WITH SecondTable.FieldValue
>ENDSCAN
>
>SET RELATION OFF INTO SecondTable
>

>
>Thanks in advance.

VPNs can be very slow, so opening a large VFP table across a VPN can be very slow as well. Also, if the connection is not 100% reliable, a temporary network dropout can cause VFP to think the connection has been lost, which can corrupt the table and/or .DBC.

To avoid those kinds of problems, you can use the VPN to copy one set of data from one location to the other, so they are both in the same place. If that place is at your location, you can then update quickly at high speed, then copy the updated files back. If it's at the remote location, you'd need to somehow get a remote session via LogMeIn, Terminal Server etc.

If you must open the table via VPN, I understand it *may* be possible to reduce network traffic through careful/clever use of index tags on the remote table. You may also get better results using SQL commands such as UPDATE - SQL. I don't use this scenario so I can't help you with any details.