For this operation, using SPT to create the cursor should be considerably faster; that cursor could then be appended locally into your table.

Hank Fay

>I have a software package that I am converting from single user to multi-user. The program will not run on the servers of my clients because of speed problems, so I solve the problem as below:
>
>1) Only one person can use it at a time
>2) As each person uses it, they transfer key files from the local machine to the server when they log off.
>3) If a new person logs on, the person is recognized as a new user and the key files automatically download to the local hard drive of the new user.
>
>We are now finding that the files don't always transfer down as expected.
>
>I am using the following commands:
>1) Use current local file excl
>2) Zap
>3) Appe from server file
>
>I am wondering if this is good code for the file transfer. Instead I could copy the server file to the local directory then append from it with both files on the local machine.
>
>The largest files are in the order of 10,000 records.
>
>Is the APPEND FROM a good command to use for network transfers or would I be better to do this in another way?
>
>
>Mike Smith