VFP will probably support several hundred simultaneous users in such a scenario. SQL Server will give you several other advantages like security, on-line incremental backup, replication, no 2G table limit, real transactions, etc.

If you use views it is pretty easy to upsize to client/server. You can even upsize pretty easily if you write a function that handles all of your queries. You just send it each SELECT statement and have it run it in VFP using macro expansion or send it to the server with SQLEXEC() depending on what back end you're using. Keep your SQL very generic and do anything more complex using VFP code after your initial query.

>However, I'd still like to get some feedback from you or others on the number of users VFP will support (especially in a "connectionless" IIS scenario).
>
>Thanks for your comments,
>
>-Bernie