>Here they are - please feel free to help yourselves!
>
>1. How to stop multiple instances of your app being opened on the same PC.

There's an API call you can make, but I don't remember what it is. Perhaps someone else will chime in.

>
>2. How to 'distract' the user for a few seconds while large files open, so they don't think diddly is happening, and try opening the exe again.

It shouldn't take much more time to open a large file than a small one. Can you post the code to open the large file?

>3. Any way to reset a data environment to 'virgin' state - as it was after tables were opened in data environment. The app presently has a load of tables open, and runs child windows sharing those tables. Every nowwwww and then something happens to upset the apple cart all of a sudden it's brains are scrambled - I am sure it is returning with an index out of order, or a filter not reset, but the plowing thru the code on a low budget - oi...

You're going to have to trap for that scrambled state first. It actually might be easier to fix the real problem. If a child form reuses the environment, it should store all the environment settings when it opens and restores them when closed. This is one reason I avoid SET FILTER and simply use views and SQL SELECT statements.

>
>4. The app I am supporting runs on a server - each PC is mapped to it, and runs the exe on the server. Would it be a lot faster if the exe were to run on the local PC, and just have the data mapped? And what are the demons to look for in that?

Runs on the server?? I'm not so sure about that. It may be stored on the server but it will run locally. Yes, it will be faster to store it locally. Make sure temp files are mapped to a local drive.

>
>I know there were more, but after a 17hr day, they have gone missing, and I will post them when they return.
>
>Thanks for the help!