Steve,
Joseph's suggestion of using remote automation is a good one. Some other things to consider:
- Running the process on a client and putting the temp files on the server will make things worse. The processing will still happen at the client and the client will now have to write temp files to the server. This will mean more network traffic. Putting the temp files on the client will reduce traffic a little.
- You could just run your application on the server. This will only work if you have an NT or Windows 95 server, of course (the same is true for remote automation). Your network people might object, but if you only do it once in a while it's not such a big deal.
>Most of us here I'm sure have a mechanism to do indexing and packing of an application's tables as an on-line option. Is there a way to be able to keep the operation at the server rather than having all the data sent across a network for processing by a local client? Can the tempfiles (pack's implicit copy file) be kept on the server?
>
>Thanks,
>Steve