>The question is should we still be using VFP for the kind of requirements I have mentioned.

Yes, but what level of security were you after? For some people WinNt security is enough. There are also new security features coming for VFP 7, and you can always go the COM object route where the data is in a directory that is only available to the COM "user" and the COM object is accessed by a password scheme.


>Is MSDE/SQL-Server with VB front-end also a good option ?

An SQL database would satisfy the security issues for most people. Since they don't have much in the way of front ends the front end platform should be whatever you

1. Feel most comfortable working in
2. Feel that those coming after you will be able to support

- in other words, much less to do with number of users or security.





>Rakesh
>
>
>
>>Rakesh,
>>
>>The single user/multiple users issue is pretty simple. SET EXCLUSIVE ON/OFF. ;-) If you have private data sessions this is scoped to the data session so be sure to watch out for that.
>>
>>Security is different. It can mean different things to different people, and a lot will depend on exactly what your customers have in mind. Some may be content with a simple login feature, some may be content with encryption, some may be content with what WinNT has to offer. If necessary, you may have to use an SQL database as the back end, or a COM object as a go-between. Written correctly, the same app can be used against native tables and an SQL back end. This would involve using views for the data and just changing the source of the views.
>>
>>Some folks that do more with security will add to this, I'm sure.
>>
>>
>>
>>
>>>I have been following the threads for the past few weeks about VFP/other tools.
>>>
>>>We have just started learning VFP. Our Application will be used by 3 category of users
>>>
>>>Single User ( Maximum )
>>>upto 5 users
>>>> 5 User ( minimum )
>>>
>>>We also need to incorporate secuity features for multi-user s/w.
>>>
>>>Is any other tool ( VB/Delpi etc ) MORE suitable for the above application than VFP ?