Thanks again Bob


>There are many improvements in VFP since Version 6 so I would definately reccommend upgrading. Many people use SQL Server with VFP, for several different reasons. VFP tables were never designed for the security enviroment we face today. The data is not encrypted, the files can be opened by anyone with a little knowledge, and it is possible to corrupt the files under the right senerio. As for scalability, more data is pulled across the network to get the job done. More users pulling more data means more bandwidth required. You can also offload some of your processing on the SQL Server (using stored procedures).
>
>That being said, VFP tables are just fine for many smaller applications where these things are not critical.
>
>Bob
>
>>>They are not mutually exclusive and SQL Server is not a complete solution, only the data part (Not used for the user interface). Many VFP developers use SQL Server for their data store because of security and scalability. You can also use other languages to access SQL Server.
>>>
>>>Bob
>>>
>>>>A comment from a prominent IT guy in the UK - don't use VFP use SQL
>>>>
>>>>Any comments
>>>>
>>>>Colin
>>
>>Bob
>>
>>That's useful - can you elaborate on scalability and security if you have time
>>
>>Also as VFP6 does all I need it to do are there any security / reliability / speed issues that would benefit from an upgrade to VFP9?
>>
>>Colin