Seems like a lot of trouble when you can buy a small server for $1000 or so... that will easily handle several users. You are coding a solution to a network/hardware problem.
I went to dell.com and priced out a 2.4ghz server with MS 2003 Small biz server,256mbram,40gb drive for $947.
-w-
>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
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown