Aashish,
Sometimes you just need to convince the client that they are an idiot, in the nicest possible way. *s*
Querying the database once a second to find the number of users attached, isn't going to do anything but slow down the performance of the backend. So if they are trying to turn Oracle into a VFP server
Multithreading VFP isn't going to help all that much in this case anyway. VFP is just sitting there waiting for the return of the SQL call you made to the backend. You should use an Asynchronous connection if you want to let the machine multitask better. But there is quite a bit more work involved with trying to deal with an Asynchronous connection and frankly I'd say it's not worth the effort.
>That's what exactly i did but the client need to refresh every second and hence gave him the second option i.e. All new EXE for his work.